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
Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo

EXECUTE IMMEDIATE Statement   The EXECUTE IMMEDIATE statement prepare (parses) and instantly executes a dynamic SQL statement or an anonymous PL/SQL block. Syntax:

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com

Logical Operators The logical operators AND, NOT, and OR follow the tri-state logic shown in table below. The AND and OR are binary operators; NOT is a unary operator.

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE