You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for ELSIF


1 to 20 of 55 results. Previous page Prev  Next next page
Results per page:   20  | 40


User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

IF-THEN-ELSIF Statementof IF statement uses the keyword ELSIF (not ELSEIF ) to introduce additional conditions, as follows … : IF condition1 THEN sequence_of_statements1 ELSIF condition2 THEN sequence_of_statements2 ELSE … sequence_of_statements3 END IF; If the first condition is false or , the ELSIF clause tests another … condition. An IF statement

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 25 of 52

Keyword and Parameter DescriptionIf control reaches this keyword, the sequence of statements that follows it is executed. ELSIF This … expressions following any preceding ELSIF s yield FALSE or NULL. THEN This keyword associates the

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 25 of 52

Usage NotesThere are three forms of IF statements: IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. The simplest form … executed. The third form of IF statement uses the keyword ELSIF to introduce additional Boolean … expressions. If the first expression yields FALSE or NULL, the ELSIF clause evaluates another expression … . An IF statement can

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 34 of 52

Examplesemp 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 = 20; END IF; END; END … BEGIN IF choice = 1 THEN OPEN generic_cv FOR SELECT * FROM emp; ELSIF choice = 2 THEN OPEN generic_cv … FOR SELECT * FROM dept; ELSIF

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

Guidelines for PL/SQL Conditional Statementscondition in the second IF statement, as follows: IF overdrawn THEN... When possible, use the ELSIF … ; | statement1; ELSE | ELSIF condition2 THEN IF condition2 THEN | statement2; statement2; | ELSIF condition3 THEN … simplify the logic by using a single CASE statement instead of an IF with several ELSIF clauses.

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Interaction Between PL/SQL and Oracle

Cursor Variable Example: Master Table and Details Tablesbook_title = title; ELSIF code = 2 THEN OPEN lib_cv FOR SELECT * FROM periodicals WHERE periodical_title … = title; ELSIF code = 3 THEN OPEN lib_cv FOR SELECT * FROM tapes WHERE tape_title = title; END IF; END find_item;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Overview of PL/SQL

Cursor Variablesemp; ELSIF choice = 2 THEN OPEN generic_cv FOR SELECT * FROM dept; ELSIF choice = 3 THEN OPEN generic_cv FOR SELECT * FROM salgrade; END IF;... END;

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Control Structures

Conditional Control: IF and CASE Statements-ELSE, and IF-THEN-ELSIF. The CASE statement is a compact way to evaluate a single condition and choose between many alternative actions.

Label Security Administrator's Guide, 9i Release 2 (9.2.0.2)

Implementing Policy Options and Labeling Functions

Creating a Labeling Functioni_label varchar2(80); Begin /* Determine Class Level */ if total_sal > 2000 then i_label:= 'L3:'; elsif

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 13 of 52

Examplesblock. */ EXEC SQL EXECUTE BEGIN IF:choice = 1 THEN OPEN:generic_cv FOR SELECT * FROM emp; ELSIF … :choice = 2 THEN OPEN:generic_cv FOR SELECT * FROM dept; ELSIF:choice = 3 THEN OPEN:generic_cv FOR … OPEN emp_cv FOR SELECT * FROM emp WHERE comm IS NOT NULL; ELSIF choice = 2 THEN OPEN emp_cv FOR SELECT … * FROM emp WHERE sal >

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Language Elements, 25 of 52

Examplesexecuted. The expression associated with ELSIF is never evaluated and control passes to the INSERT

Replication Management API Reference, 9i Release 2 (9.2.0.2)

User-Defined Conflict Resolution Methods

Examples of User-Defined Conflict Resolution Methodnew 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 old is , then

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Coding Dynamic SQL Statements

Executing Dynamic PL/SQL Blocksevent_dispatcher (event number, 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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

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

Replication Management API Reference, 9i Release 2 (9.2.0.2)

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, rmt_epoch

JPublisher User's Guide, 9i Release 2 (9.2.0.2)

JPublisher Examples

The User-Defined BOOLEANS DatatypeBEGIN iOut:= iIn; IF iInOut IS NULL THEN iInOut:= 0; ELSIF iInOut = 0 THEN iInOut:= 1; ELSE iInOut

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

Scripts for Implementing BooksOnLine

tkaqdoce.sql: Operational Examplesback_order_queue_name:= 'WS.WS_backorders_que'; ELSIF sale_region = 'EAST' THEN back_order_queue_name

User's Guide and Reference, 9i Release 2 (9.2.0.2)

Sample PL/SQL Programs

PL/SQL Block… */ /*--------------------------------------------*/ ELSIF acct.oper_type = 'I' THEN BEGIN INSERT INTO … wasn't found. */ /*--------------------------------------------*/ ELSIF acct.oper_type = 'D' THEN

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

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

Streams, 9i Release 2 (9.2.0.2)

Monitoring a Streams Environment

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