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
Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

Updating by replacement Syntax: UPDATE ENROLMENT SET Name = 'Ann' WHERE StudentId = SID ('S1'); Note the use of SET, as already noted in connection with direct a

Parameter and Keyword Description:   table_reference: This keyword identifies the table or view that should be accessible when you execute the UPDATE statement, and for wh

I need a query for PL/SQL, selecting names with cursor, goes down the list, assigns usernames (initials001) based on initials in the name. If two names have same initials the user

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN

Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

Example of ADD CONSTRAINT in SQL Example: Alternative formulation for MAX_ENROLMENTS ALTER TABLE IS_ENROLLED_ON ADD CONSTRAINT MAX_ENROLMENTS CHECK ((SELECT COUNT (*)

Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot