Where do you use decode and case statements?
Answer / Pankaj Kumar Tripathi
Decode and Case statements are used in Oracle for conditional logic within SQL queries. DECODE is a function that provides an alternative to IF-THEN-ELSE logic, while CASE enables more complex conditions using the WHEN-THEN syntax.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is ASM (Automatic Storage Management) in Oracle?
what is Table ?
What is null value in oracle?
if you update view? where we store the data?
What a SELECT FOR UPDATE cursor represent.?
What is the sid in oracle?
Display Odd/ Even number of records?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
What is oracle in java?
How to create id with auto_increment on oracle?
What is a Data Segment ?
What are the attributes that are found in a cursor?