What are the two types of case statements in PL SQL?

What is CASE statement in PL SQL?

The PL/SQL CASE statement facilitates you to execute a sequence of satatements based on a selector. A CASE statement is evaluated from top to bottom. … If it get the condition TRUE, then the corresponding THEN calause is executed and the execution goes to the END CASE clause.

What are types in PL SQL?

Data types (PL/SQL)

PL/SQL data type DB2® SQL data type Description
INTEGER INTEGER Signed four-byte integer numeric data
LONG CLOB (32760) Character large object data
LONG RAW BLOB (32760) Binary large object data
LONG VARCHAR CLOB (32760) Character large object data

What are the two types of comment that can be used in PL SQL?

PL/SQL supports two comment styles: single-line and multi-line.

Which keyword is used for terminating CASE statement in PL SQL?

The END CASE clause is used to terminate the CASE statement.

Can we write CASE in where clause?


We can use a case statement in Where, Order by and Group by clause. … So, by using a CASE statement with the where condition displays the result.

THIS MEANING:  Which one is better JSP or PHP?

Can I use CASE statement in where clause?

CASE can be used in any statement or clause that allows a valid expression. For example, you can use CASE in statements such as SELECT, UPDATE, DELETE and SET, and in clauses such as select_list, IN, WHERE, ORDER BY, and HAVING.

Is table of PL SQL?

Objects of type TABLE are called PL/SQL tables, which are modeled as (but not the same as) database tables. For example, a PL/SQL table of employee names is modeled as a database table with two columns, which store a primary key and character data, respectively.

How do I create a multi line comment in PL SQL?

PL/SQL supports two comment styles: single-line and multi-line. Single-line comments begin with a double hyphen ( – – ) anywhere on a line and extend to the end of the line. Multi-line comments begin with a slash-asterisk ( /* ), end with an asterisk-slash ( */ ), and can span multiple lines.

Where do you declare variables in PL SQL procedures?

PL/SQL variables must be declared in the declaration section or in a package as a global variable. When you declare a variable, PL/SQL allocates memory for the variable’s value and the storage location is identified by the variable name.

How do I comment multiple lines in Oracle SQL Developer?

6 Answers. In SQL Developer, I highlight all lines of PL/SQL that I want commented and use Ctrl + / . Obviously, you would like a way to comment and uncomment multiple lines quickly. This will put — in front of each line you have highlighted.