This tutorial will explain how to use Oracle Case Statement expression with basic syntax and many examples for better understanding. And don't forget ...
Post
Oraask Latest Articles
Post
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 ...
Post
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.
Post
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 ...
Post
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 ...
Post
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 ...