Results for ELSE


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


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;





Was this page helpful?

Integrated Cloud Applications & Platform Services