Results for ELSE


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


DML Reference, 10g Release 1 (10.1)

IF...THEN...ELSE

IF...THEN...ELSEThe IF...THEN...ELSE command executes one or more commands in a program when a specified condition … expression. See "IF as a Conditional Operator". Syntax IF  boolean-expression    THEN  statement1    [ELSE  statement2 ] Arguments

DML Reference, 10g Release 1 (10.1)

IF...THEN...ELSE

boolean-expressionline as THEN. ELSE statement2 Oracle OLAP executes the statement2 argument when the Boolean expression … is FALSE. The statement2 must be on the same line as ELSE. When you omit the ELSE phrase, execution … or ELSE (or both) keywords with a DO... DOEND sequence. See Example 14-13, "Using IF...THEN...ELSE

Release 1.8, 10g Release 1 (10.1)

Oracle Reserved Words, Keywords, and Namespaces

ACCESS ELSE MODIFY STARTADD EXCLUSIVE NOAUDIT SELECT ALL EXISTS NOCOMPRESS SESSION ALTER FILE NOT SET AND FLOAT NOTFOUND SHARE ANY FOR NOWAIT SIZE ARRAYLEN FROM NULL SMALLINT AS GRANT NUMBER SQLBUF ASC GROUP OF SUCCESSFUL AUDIT HAVING OFFLINE SYNONYM BETWEEN IDENTIFIED ON SYSDATE BY IMMEDIATE ONLINE TABLE CHAR IN OPTION THEN CHECK INCREMENT OR TO CLUSTER INDEX ORDER TRIGGER COLUMN INITIAL PCTFREE UID COMMENT INSERT PRIOR

Oracle Database, 10g Release 1 (10.1)

Apache Tutorial: Introduction to Server Side Includes

What else can I config?processing this directive] If you want to change that message to something else, you can do so with the

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

4 Using PL/SQL Control Structures

Using the IF-THEN-ELSE StatementThe second form of IF statement adds the keyword ELSE followed by an alternative sequence of … statements: IF condition THEN sequence_of_statements1 ELSE sequence_of_statements2 END IF; The statements … in the ELSE clause are executed only if the condition is false or . The IF-THEN-ELSE statement … = balance +

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

OCI Any Data Interface Functions

isNull (IN/OUT)TRUE if NULL, else FALSE.

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

OCI Table Functions

exists (OUT)FALSE if no previous index is available, else TRUE.

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

OCI NUMBER Functions

result (OUT)Set to TRUE if integer value else FALSE

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

OCI Table Functions

exists (OUT)FALSE if no next index is available, else TRUE.

Error Messages, 10g Release 1 (10.1)

56 PCC-00001 to PCC-01515

PCC-00004: Mismatched IF/ELSE/ENDIF block at line number in file stringstatement ahead of the line in error. PCC-00004: Mismatched IF/ELSE/ENDIF block at line number in file string

Error Messages, 10g Release 1 (10.1)

56 PCC-00001 to PCC-01515

PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or "."group item. PCC-01009: For hostlan = COB74, a SQL statement must be followed by ELSE or "."

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

RefAny Class

isNull()Returns TRUE if the object pointed to by this ref is NULL else FALSE. Syntax bool isNull() const;

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

OCI Collection and Iterator Functions

exists (OUT)Is set to FALSE if the element at the specified index does not exist, else it is set to TRUE.

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

OCI Type Information Accessor Functions

type_name (IN)Name of the type to get. This string must be all in upper-case, or else OCI throws an internal error and the program stops.

Constant Field Values (Oracle® XML Java API Reference), 10g Release 1 (10.1)

validateElementContent

validateElementContent. Parameters: e - Element to be validated Returns: True if valid, else false

Packages and Types Reference, 10g Release 1 (10.1)

63 DBMS_PIPE

Exceptions: Insufficient privilege to remove pipe. The pipe was created and is owned by someone else.

Packages and Types Reference, 10g Release 1 (10.1)

104 DBMS_UTILITY

Examples); dbms_output.put('parameter value is: '); IF partyp = 1 THEN dbms_output.put_line(strval); ELSE … dbms_output.put_line('string'); ELSE dbms_output.put_line('integer'); END IF; END;

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

OCI Type Information Accessor Functions

schema_name (IN, optional)must be all in upper-case, or else OCI throws an internal error and the program stops.

Constant Field Values (Oracle® XML Java API Reference), 10g Release 1 (10.1)

isSupported

isSupportedby: isSupported in interface Node Returns: true,if the feature is supported else false

Packages and Types Reference, 10g Release 1 (10.1)

63 DBMS_PIPE

Exceptionserror. Insufficient privilege to remove the record from the pipe. The pipe is owned by someone else.

Packages and Types Reference, 10g Release 1 (10.1)

63 DBMS_PIPE

Exceptions… Insufficient privilege to write to the pipe. The pipe is private and owned by someone else.

DML Reference, 10g Release 1 (10.1)

14 GET to IMPORT

14 GET to IMPORTHEADING HIDE HIERCHECK HIERHEIGHT command HIERHEIGHT function IF...THEN...ELSE IMPORT IMPORT (from EIF) IMPORT (from text) IMPORT (from spreadsheet)

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

4 Using PL/SQL Control Structures

Using the IF-THEN-ELSIF StatementELSEIF or ELSE IF ) to introduce additional conditions: IF condition1 THEN sequence_of_statements1 ELSIF … condition2 THEN sequence_of_statements2 ELSE sequence_of_statements3 END IF; If the first condition … ELSIF clauses; the final ELSE clause is optional. Conditions are evaluated one by one from top to … to the next statement.

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

4 Using PL/SQL Control Structures

Using the CASE Statement'); ELSE dbms_output.put_line('No such grade'); END IF; Notice the five Boolean expressions. In each … dbms_output.put_line('Poor'); ELSE dbms_output.put_line('No such grade'); END CASE; The CASE statement is … , control passes to the next statement. The ELSE clause works similarly to the ELSE clause in an IF

DML Reference, 10g Release 1 (10.1)

3.1 Introducing OLAP DML Expressions

3.1.1 How the Data Type of an Expression is Determinedan IF... THEN. . . ELSE operator is supported. A conditional expression returns a value whose data … type depends on the expressions in the THEN and ELSE clauses, not on the expression in the IF … clause, which must be BOOLEAN. Note: Do not confuse a conditional expression with the IF...THEN...ELSE

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

OCI Any Data Interface Functions

OCIAnyDataGetCurrAttrNum()constructed, it refers to the current attribute that is being set. Else, if the OCIAnyData is being accessed, it refers to the attribute that is being accessed.

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

6 Embedded SQL

6.2.2 Returned NULLs=:emp_number; if (ind_comm == -1) pay = salary; /* commission is NULL; ignore it */ else pay = salary + commission;

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

5 Embedded SQL

5.2.4 Handling Returned NULLs=:EMP_NUMBER END-EXEC. IF IND-COMM = -1 MOVE SALARY TO PAY. * -- commission is ; ignore it ELSE ADD SALARY TO COMMISSION GIVING PAY. END-IF.

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

A Handle and Descriptor Attributes

Attribute Datatype, errhp); if (serverStatus == OCI_SERVER_NORMAL) printf("Connection is up.\n"); else if (serverStatus == OCI_SERVER_NOT_CONNECTED) printf("Connection is down.\n");

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

Connect, Authorize, and Initialize Functions

found (OUT)returned (that is, the value of tagInfo and retTagInfo is the same), then found is set to TRUE, else, found is set to FALSE.

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

2 OCI Programming Basics

Example of Getting Locale Information in OCI!= OCI_SUCCESS) { checkerr(errhp, ret, OCI_HTYPE_ERROR); ret = OCI_ERROR; } else { printf("NLS linguistic: %s\n", infoBuf); } return(ret); }

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

alter system set dispatchersnew dispatchers have started else the session will wait again Parameter Description waited Number of times that the session has waited 1 / 100 of a second

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

A Handle and Descriptor Attributes

Attribute Datatype); if (in_v8_mode) fprintf (stdout, "In V8 mode\n"); else fprintf (stdout, "In V7 mode\n"); OCI_ATTR_SERVER

Packages and Types Reference, 10g Release 1 (10.1)

182 XMLTYPE

SCHEMAVALIDATEnon-schema based documents an error is raised. If validation fails an error is raised; else, the

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

2 Fundamentals of the PL/SQL Language

CASE ExpressionsexpressionN THEN resultN [ELSE resultN+1] END The selector is followed by one or more WHEN clauses … ' WHEN 'D' THEN 'Fair' WHEN 'F' THEN 'Poor' ELSE 'No such grade' END; dbms_output.put_line('Grade … ' || grade || ' is ' || appraisal); END; / The optional ELSE clause works similarly to the ELSE clause in … ,

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

4 Using PL/SQL Control Structures

Guidelines for PL/SQL Conditional Statements; | statement1; ELSE | ELSIF condition2 THEN IF condition2 THEN | statement2; statement2; | ELSIF condition3 … THEN ELSE | statement3; IF condition3 THEN | END IF; statement3; | END IF; | END IF; | END IF

Packages and Types Reference, 10g Release 1 (10.1)

24 DBMS_DATA_MINING_TRANSFORM

Usage Notesclipping expressions of the following form: CASE WHEN "col" rcut THEN rval ELSE "col" END "col … is generated: CASE WHEN "my_col" 4.5 THEN NULL ELSE "my_col" END "my_col"

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

11 Object-Relational Datatypes in OCI

REF Example("After first OCIRefIsEqual:\n"); if(refs_equal) printf("REFs equal\n"); else printf("REFs not equal … (envhp, ref1, ref2); printf("After second OCIRefIsEqual:\n"); if(refs_equal) printf("REFs equal\n"); else printf("REFs not equal\n");

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 … := i_label||'M:'; else i_label:= i_label||'E:'; end if; /************* Determine Groups

Packages and Types Reference, 10g Release 1 (10.1)

151 UTL_COLL

Examplespno=1; IF (UTL_COLL.IS_LOCATOR(plist)) THEN DBMS_OUTPUT.PUT_LINE('plist is a locator'); ELSE … DBMS_OUTPUT.PUT_LINE('plist1 is a locator'); ELSE DBMS_OUTPUT.PUT_LINE('plist1 is not a locator'); END IF; END chk_coll; SET SERVEROUTPUT ON EXECUTE chk_coll;

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

2 Fundamentals of the PL/SQL Language

Lexical Unitsor tabs. The formatting makes the IF statement on the right more readable: IF x>y THEN max:=x;ELSE … max:=y;END IF; | IF x > y THEN | max:= x; | ELSE | max:= y; | END IF;

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

IF Statement

IF Statementreturns TRUE. ELSE If control reaches this keyword, the sequence of statements that follows it is … three forms of IF statements: IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. The simplest form of IF … statement. The second form of IF statement adds the keyword ELSE followed by an alternative sequence … of statements. The sequence

Guide, 10g Release 1 (10.1)

21 SQL for Analysis and Reporting

Creating Histograms With User-Defined Buckets(CASE WHEN cust_credit_limit BETWEEN 0 AND 3999 THEN 1 ELSE 0 END) AS "0-3999", SUM(CASE WHEN … cust_credit_limit BETWEEN 4000 AND 7999 THEN 1 ELSE 0 END) AS "4000-7999", SUM(CASE WHEN cust_credit_limit … BETWEEN 8000 AND 11999 THEN 1 ELSE 0 END) AS "8000-11999", SUM(CASE WHEN cust_credit_limit BETWEEN … 12000 AND 16000 THEN 1

Oracle Database, 10g Release 1 (10.1)

Apache Tutorial: Dynamic Content with CGI

What's going on behind the scenes?access to the error log, you should probably host your site somewhere else. Learn to read the error

Oracle Database, 10g Release 1 (10.1)

Apache Tutorial: Introduction to Server Side Includes

Apache HTTP Server Version 1.3document modified? Including a standard footer What else can I config? Executing commands Advanced SSI

API Reference, 10g Release 1 (10.1)

Document Interface

XmlDomGetSchemaReturns URI of schema associated with document, if there is one, else returns NULL. The XmlLoadDom

API Reference, 10g Release 1 (10.1)

Element Interface

XmlDomRemoveAttrNode-created with that value (Specified set to FALSE ). Returns the removed attribute on success, else NULL

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

Cartridge Services -- File I/O Interface

create (IN)file. OCI_FILE_EXCL -- fail if the file exists, else create. OCI_FILE_CREATE -- open the file if it

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

Reference, 10g Release 1 (10.1)

12 CTX_THES Package

phrase'); if (result) then dbms_output.put_line('TRUE'); else dbms_output.put_line('FALSE'); end if; end;

API Reference, 10g Release 1 (10.1)

GetAttribute (Oracle Workflow API Reference)

GetAttribute, myNid, myAttr); } else if (myAttrType == "NUMBER") { value = (WFNotificationAPI.getAttrNumber(ctx … , myNid, myAttr)).toString(); } else if (myAttrType == "DOCUMENT") { value … = WFNotificationAPI.getAttrDoc(ctx, myNid, myAttr, ); } else value = WFNotificationAPI.getAttrText(ctx, myNid, myAttr

Utilities, 10g Release 1 (10.1)

12 SQL*Loader Case Studies

Creating a BEFORE INSERT Trigger… last_deptno:=:new.deptno; -- save value for later ELSE:new.deptno:= uldemo7.last_deptno; -- use last … valid value END IF; IF:new.job IS NOT NULL THEN uldemo7.last_job:=:new.job; ELSE:new.job:= uldemo7 … .last_job; END IF; IF:new.mgr IS NOT NULL THEN uldemo7.last_mgr:=:new.mgr; ELSE:new.mgr

Release 1.8, 10g Release 1 (10.1)

Info

Notationorder_total; subtract quantity from quantity_on_hand; create order_line; ELSE create back_order; ENDIF … ; ELSE display 'Invalid catalog number'; ENDIF; ENDFOR; create customer_order; ELSE display 'Credit

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

4 IMExample Java Sample Application

4 IMExample Java Sample Application… OrdMediaUtil.imCompatibilityInit(s_dbConn); } else { new IMMessage(IMConstants.ERROR, "ALREADY_CONNECTED"); } } Calling the … )) { // The image does not exist. m_hasMedia = false; layoutEmpty(s_sNotExist); } else { m_hasMedia … , m_imgThumb); } byte[] thumbnail = getDataInByteArray(m_imgThumb); addThumbnail(thumbnail); } else

SQL Reference, 10g Release 1 (10.1)

CASE Expressions

CASE ExpressionsCASE expressions let you use IF... THEN... ELSE logic in SQL statements without having to invoke … ... THEN pairs meet this condition, and an ELSE clause exists, then Oracle returns else_expr … ELSE clause exists, Oracle returns else_expr. Otherwise, Oracle returns . For a simple CASE … and the optional ELSE expression.

Security Guide, 10g Release 1 (10.1)

16 Developing Applications Using Data Encryption

Example of Encrypt/Decrypt Procedures for BLOB Data('Source BLOB Len NULL '); ELSE dbms_output.put_line('Source BLOB Len ' || leng); END IF; leng … := DBMS_LOB.GETLENGTH(encrypblob); IF leng IS NULL THEN dbms_output.put_line('Encrypt BLOB Len NULL '); ELSE … leng IS NULL THEN dbms_output.put_line('Decrypt BLOB Len NULL '); ELSE dbms_output.put_line('Decrypt … := DBMS_LOB.GETLENGTH(srcblob);

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 … UPDATE accts SET bal = bal -:trans_amt WHERE acctid =:acct_num;:status:= 'Debit applied'; ELSE … :status:= 'Insufficient funds'; END IF; ELSE:status:= 'Invalid type: ' ||:trans_type; END IF

Oracle® SQL*Module for Ada Programmer's Guide, 10g Release 1 (10.1)

3 Accessing Stored Procedures

3.1 PL/SQLcontrol execution flow, using IF... THEN... ELSE, EXIT, GOTO, and other procedural constructs create

Pro*COBOL® Programmer's Guide, 10g Release 1 (10.1)

2 Precompiler Concepts

2.2.25 Sentence TerminatorEMP-NUMBER = ZERO MOVE FALSE TO VALID-DATA PERFORM GET-EMP-NUM UNTIL VALID-DATA = TRUE ELSE EXEC SQL

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

5 Advanced Topics

5.6 The Oracle Preprocessordefined EXEC ORACLE IFNDEF symbol; -- if symbol is not defined EXEC ORACLE ELSE; -- otherwise EXEC ORACLE





Was this page helpful?

Integrated Cloud Applications & Platform Services