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
Keyword & Parameter Description: WHEN: This keyword introduces the exception handler. You can have many exceptions execute the similar sequence of the statements by follo

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illu

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Using Operator REF: You can retrieve refs by using the operator REF that, like VALUE, takes as its argument a correlation variable. In the illustration below, you retrieve one

Database Values You can use the SELECT statement to have the Oracle assign values to a variable. For Each and every item in the select list, there must be a matching, type-compa

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

Need for Dynamic SQL: You need dynamic SQL in the situations as follows: 1) You would like to execute a SQL data definition statement (like CREATE), a data control statemen

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal