answersLogoWhite

0

The Case Statement in Oracle is a command that evaluates a condition (or a sequence of conditions) for one or multiple expressions. According to the value of those expressions a corresponding statement is executed.

User Avatar

Wiki User

11y ago

What else can I help you with?

Related Questions

What is an expression in Oracle Database?

select statement in oracle which is used to calculate average,min,max etc is an expression


Which of the following is a true statement a the Delphic oracle's statement comes true b the sphinx prevails over Thebes c Oedipus kills his mother d the Delphic oracle's s?

The Delphic oracle's statement comes true. (Apex)


What are the differences between SQL statement to iSQL plus statement?

Structured Query Lanaguage(SQL) is a command language to communicate with oracle server.whereas SQL*PLUS is an oracle tool that recognises and submits sql statements to the oracle server for execution.


How can one create tables in Oracle?

If one is wanting to create a table in Oracle one must use the "Create Table" statement. These tables are partially defined by the columns contained and the information in the column. One must first decide the proper column type and then these data types are used in the Create Table statement. One must be somewhat familiar with Oracle in order to create these tables and additional information can be found on the DBA-Oracle website.


What is a select case statement used for in programming?

In programming, select case statement is a way to test the inside of a variable. It is used when one knows there is a limited number of things that can be in the variable.


What font is used for the oracle logo?

Oracle


What is the difference between bulk collect and for all in oracle 8i and 9i?

Bulk collect: is a CLAUSE. is used to fetch the records from the cursor. Forall: is a STATEMENT. is used to do dml operation of fetched records. The body of the FORALL statement is a single DML statement -- an INSERT, UPDATE, or DELETE.


What is case in java?

Case is used to label each branch in the switch statement in Java Program


Where were oracle bones used to predict the future?

Oracle bones were used in China.


What is oracle pft?

Oracle PFT = Oracle Profitability Manager which is a tool used in the financial end.


What can oracle forms be used for?

Oracle forms are part of a programming language and are used to deploy oracle forms. These are used by developers creating apps for the Android operating system.


What is the use of switch statement in java?

In java, a switch statement is used to simplify a long list of 'if' statements. A switch statement takes the form of:switch (variableName){case condition1; command1;case condition2; command2;...}