Before changing or making a significant update on a database table in all databases and Oracle specifically, we have to take a backup ...
Article
Oraask Latest Articles
Article
Oracle Case Statement
Oracle Case Statement
6 mins read
This tutorial will explain how to use Oracle Case Statement expression with basic syntax and many examples for better understanding. And don't forget ...
Article
Check Tablespace Usage in Oracle
Check Tablespace Usage in Oracle
6 mins read
When it comes to databases in general and oracle specifically, we hear the term " tablespace " when trying to create a database ...
Article
Run Oracle SQL Script From Command Line in Windows
Run Oracle SQL Script From Command Line in Windows
1 mins read
Sometimes we have a requirement to run a particular SQL script from windows command line "CMD" with or without parameters.
Article
RICE , RICEW And FRICE components in oracle apps
RICE , RICEW And FRICE components in oracle apps
1 mins read
Introductions: RICE, RICEW and FRICE Components in oracle apps. Many times, we saw and heard many terminologies especially in job ...
Article
Enable Diagnostics in Oracle apps
Enable Diagnostics in Oracle apps
1 mins read
To enable Diagnostics in Oracle apps , for certain users you need to follow these simple steps: Step 1 ...
Article
Oracle SQL Case Statment to find if a Value is String or Number using REGEXP_LIKE
Oracle SQL Case Statment to find if a Value is String or Number using REGEXP_LIKE
1 mins read
REGEXP_LIKE is similar to the LIKE condition, except REGEXP_LIKE performs regular expression matching instead of the simple pattern matching performed by LIKE. This ...