Get started Bring yourself up to speed with our introductory content.

The Oracle Guru Question #13

Are you an Oracle guru? Take our quiz and see how much you really know about Oracle.

QUESTION OF THE WEEK:

In version 8.1, Oracle introduced this statement into SQL, which allowed the use of operators like > and BETWEEN, and permitted different values to be compared in different branches of the statement. It evaluates successive WHEN-conditions and, if true, returns a corresponding THEN-value.

a. DECODE
b. Searched CASE
c. Simple CASE

See ANSWER

Dig Deeper on Oracle DBA jobs, training and certification

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close