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
Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc

Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Cause of Indeterminacy in SQL One root cause of indeterminacy in SQL lies in its implementation of comparison for equality. For certain system-defined types it is possible for

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

Table Comparison - SQL The following definitions for relation comparisons: Let r1 and r2 be relations having the same heading. Then: r1 ⊆ r2 is true if every tuple of r1

User-Defined Exceptions The PL/SQL defines the exceptions of your own. Dissimilar to the predefined exceptions, the user-defined exceptions should be declared and should be rai

MILLER-UREY' S EXPERIMENTAL PROCEDURES - They recreated the probable conditions on the primitive earth in the laboratory. An atmosphere containing hydrogen, ammonia, me