adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Where do you use decode and case statements?

Question Posted / Pankaj Kumar Tripathi

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to start an oracle instance?

1103

Design database draw er diagram for a certain scenario ?

4656

How to put more than 1000 values into an oracle in clause?

1115

How to use values from other tables in update statements using oracle?

1158

What is oracle latest version?

1174

How to write a left outer join with the where clause in oracle?

1155

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

How to select all columns of all rows from a table in oracle?

1132