Keyword and parameter description - if statement, PL-SQL Programming

Keyword and Parameter Description:

boolean_expression:

This is an expression which results the Boolean value TRUE, FALSE, & NULL. It is related with a series of statements that is executed only if the expression results TRUE.

THEN

This keyword relates the Boolean expression which precedes it with the series of statements that follows it. When the expression yields TRUE, the related series of statements is executed.

ELSIF:

This keyword introduce a Boolean expression to be computed if the expression following IF and all the expressions following any preceding ELSIFs results FALSE or NULL.

ELSE:

If control reaches this keyword, the series of statements which follows it is executed.

Posted Date: 10/8/2012 7:02:33 AM | Location : United States







Related Discussions:- Keyword and parameter description - if statement, Assignment Help, Ask Question on Keyword and parameter description - if statement, Get Answer, Expert's Help, Keyword and parameter description - if statement Discussions

Write discussion on Keyword and parameter description - if statement
Your posts are moderated
Related Questions
Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi

Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE

Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

Packages The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the bod

Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is