Results for ELSIF


1 to 20 of 53 results. Prev  Next
Results per page:   20  | 40


User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the IF-THEN-ELSIF StatementSometimes you want to choose between several alternatives. You can use the keyword ELSIF (not … ELSEIF or ELSE IF ) to introduce additional conditions: IF condition1 THEN sequence_of_statements1 ELSIF … is false or , the ELSIF clause tests another condition. An IF statement can have any number of … ELSIF clauses;

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Guidelines for PL/SQL Conditional Statements, use the ELSIF clause instead of nested IF statements. Your code will be easier to read and … ; | statement1; ELSE | ELSIF condition2 THEN IF condition2 THEN | statement2; statement2; | ELSIF condition3 … a single expression to multiple values, you can simplify the logic by using a single CASE statement instead of an IF with several

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Testing Conditions: IF and CASE Statementsthree forms of IF statements: IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. The CASE statement is a

User's Guide and Reference, 10g Release 1 (10.1)

IF Statement

IF Statementexecuted. This occurs when none of the previous conditional tests returned TRUE. ELSIF Introduces a … three forms of IF statements: IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. The simplest form of IF … . The third form of IF statement uses the keyword ELSIF to introduce additional Boolean expressions. If … the first expression returns

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

6 Coding Dynamic SQL Statements

Executing Dynamic PL/SQL Blocks, param number) IS BEGIN IF (event = 1) THEN EVENT_HANDLER_1(param); ELSIF (event = 2) THEN … EVENT_HANDLER_2(param); ELSIF (event = 3) THEN EVENT_HANDLER_3(param); END IF; END; / Using native dynamic SQL

Advanced Replication Management API Reference, 10g Release 1 (10.1)

B User-Defined Conflict Resolution Methods

Examples of User-Defined Conflict Resolution MethodFALSE; END IF; IF new IS NULL THEN ignore_discard_flag:= TRUE; ELSIF cur IS NULL THEN … ignore_discard_flag:= FALSE; ELSIF new Additive User Function -- User function similar to ADDITIVE method. -- If

Advanced Replication Management API Reference, 10g Release 1 (10.1)

9 Managing Replication Objects and Queues

Using the AnyData Type to Determine the Value of an Argument in a Deferred CallELSIF type_name = 'INVENTORY_LIST_TYP' THEN -- anydata_val contains inventory_list_typ nested table … instance. rval:= anydata_val.GetCollection(data_ntt); -- Do something with data_ntt. ELSIF type_name … := anydata_val.GetObject(data_p); -- Do something with data_p. ELSIF type_name = 'INVENTORY_TYP' THEN -- The

Advanced Queuing User's Guide and Reference, 10g Release 1 (10.1)

A Scripts for Implementing BooksOnLine

tkaqdoce.sql: Operational Examples:= 'WS.WS_backorders_que'; ELSIF sale_region = 'EAST' THEN back_order_queue_name:= 'ES.ES_backorders_que'; ELSE

Administrator's Guide, 10g Release 1 (10.1)

8 Implementing Policy Enforcement Options and Labeling Functions

Creating a Labeling Function for a Policyi_label:= 'L3:'; elsif total_sal > 1000 then i_label:= 'L2:'; else i_label:= 'L1:'; end if

User's Guide and Reference, 10g Release 1 (10.1)

OPEN-FOR Statement

OPEN-FOR StatementNOT NULL; ELSIF choice = 2 THEN OPEN emp_cv FOR SELECT * FROM emp WHERE sal > 2500; ELSIF choice … generic_cv FOR SELECT * FROM emp; ELSIF choice = 2 THEN OPEN generic_cv FOR SELECT * FROM dept; ELSIF choice

Advanced Replication Management API Reference, 10g Release 1 (10.1)

6 Configure Conflict Resolution

Locating the Owner of a Row:= rmt_owner; loc_epoch:= rmt_epoch; RETURN; ELSIF rmt_epoch >= loc_epoch THEN get_owner(PK

Developer's Guide, 10g Release 1 (10.1)

12 User-Defined Aggregate Functions

Example: Creating and Using a User-Defined Aggregatenumber is begin if value > self.max then self.secmax:= self.max; self.max:= value; elsif value … ; self.max:= ctx2.max; elsif ctx2.max > self.secmax then self.secmax:= ctx2.max; end if; return

Concepts and Administration, 10g Release 1 (10.1)

14 Monitoring a Streams Environment

Displaying Detailed Information About Apply Errors(str); DBMS_OUTPUT.PUT_LINE(SUBSTR(str,0,253)); ELSIF tn = 'SYS.CHAR' then res:= data.GETCHAR(chr … ); DBMS_OUTPUT.PUT_LINE(SUBSTR(chr,0,253)); ELSIF tn = 'SYS.VARCHAR' THEN res:= data.GETVARCHAR(chr … ); DBMS_OUTPUT.PUT_LINE(chr); ELSIF tn = 'SYS.NUMBER' THEN res:= data.GETNUMBER(num … ); DBMS_OUTPUT.PUT_LINE(num); ELSIF

User's Guide and Reference, 10g Release 1 (10.1)

4 Using PL/SQL Control Structures

Using the CASE Statementdescriptions of school grades: IF grade = 'A' THEN dbms_output.put_line('Excellent'); ELSIF grade = 'B … ' THEN dbms_output.put_line('Very Good'); ELSIF grade = 'C' THEN dbms_output.put_line('Good'); ELSIF … grade = 'D' THEN dbms_output. put_line('Fair'); ELSIF grade = 'F' THEN dbms_output.put_line('Poor … more

User's Guide and Reference, 10g Release 1 (10.1)

6 Performing SQL Operations from PL/SQL

Controlling Cursor Variables: OPEN-FOR, FETCH, and CLOSEOPEN emp_cv FOR SELECT * FROM emp WHERE comm IS NOT NULL; ELSIF choice = 2 THEN OPEN emp_cv FOR SELECT … * FROM emp WHERE sal > 2500; ELSIF choice = 3 THEN OPEN emp_cv FOR SELECT * FROM emp WHERE deptno … , choice INT) IS BEGIN IF choice = 1 THEN OPEN generic_cv FOR SELECT * FROM emp; ELSIF choice = 2 THEN OPEN … generic_cv FOR

User's Guide and Reference, 10g Release 1 (10.1)

F List of PL/SQL Reserved Words

F List of PL/SQL Reserved Words* DO DROP* ELSE* ELSIF END EXCEPTION EXCLUSIVE* EXECUTE EXISTS* EXIT EXTENDS EXTRACT FALSE FETCH

Release 1.8, 10g Release 1 (10.1)

Oracle Reserved Words, Keywords, and Namespaces

PL/SQL Reserved WordsBOOLEAN CURRVAL DO ALL BY CURSOR DROP ALTER CASE DATABASE ELSE AND CHAR DATA_BASE ELSIF ANY CHAR_BASE

Developer's Guide, 10g Release 1 (10.1)

13 Using Pipelined and Parallel Table Functions

Input Data Streaming for Table FunctionsLOOP IF (first rec in the group) THEN cnt:= 1; sum:= rec.Sales; ELSIF (last rec in the group) THEN

Developer's Guide, 10g Release 1 (10.1)

15 Power Demand Cartridge Example

Creating the Extensible Optimizer Methods; ELSE sel:= 1; END IF; -- col = ELSIF relop = '=' THEN IF value between lo and hi THEN sel:= 1 … /ndv; ELSE sel:= 0; END IF; -- col >= ELSIF relop = '>=' THEN IF lo = hi THEN IF value ELSIF relop … = ' lo THEN sel:= 1; ELSE sel:= 0; END IF; ELSIF value between lo and hi THEN sel:= (value-lo … )/(hi-lo); ELSIF

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

7 Embedded PL/SQL

7.3.2 Complex Example; ELSE:status:= 'Credit applied'; END IF; ELSIF:trans_type = 'D' THEN -- debit the account SELECT


Was this page helpful?