Difference between case & decode?



Difference between case & decode?..

Answer / Najir Husen

"Case and Decode are both Oracle SQL functions, but they serve different purposes. CASE is used to evaluate multiple conditions in a single statement, while DECODE is used to perform conditional logic with a single condition."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Data Integrator (ODI) Interview Questions

Can i create more than one Master Repository in ODI?

1 Answers   Accenture,


how to handle exceptions?

1 Answers   Hexaware, Seventhsense Technologies,


Which profile required to access ODI Console?

1 Answers   Accenture,


What is an agent and What are the types of agents?

1 Answers   Accenture,


What is flexfileds and use of flexfileds in odi?

1 Answers   Accenture,


In topology manager where the data are stored?

1 Answers   Tech Mahindra,


What are types of LOG LEVELS in ODI?

1 Answers   Accenture,


What is the Repository and how many types of repository?

1 Answers   Tech Mahindra,


Does my odi infrastructure require an oracle database?

1 Answers   Hexaware,


suppose having unique and duplicate but I want to load unique record one table and duplicates one table?

1 Answers   Hexaware, Seventhsense Technologies,


how to load the data with one flat file and one rdbms table using joins?

1 Answers   Seventhsense Technologies,


What is the variable?

1 Answers   Infosys,


Categories
  • Oracle General Interview Questions Oracle General (1803)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)