IF...THEN...ELSE → The 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
boolean-expression → line 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
ACCESS ELSE MODIFY START → ADD 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
What else can I config? → processing this directive] If you want to change that message to something else, you can do so with the
Using the IF-THEN-ELSE Statement → The 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 +
isNull (IN/OUT) → TRUE if NULL, else FALSE.
exists (OUT) → FALSE if no previous index is available, else TRUE.
result (OUT) → Set to TRUE if integer value else FALSE
exists (OUT) → FALSE if no next index is available, else TRUE.
PCC-00004: Mismatched IF/ELSE/ENDIF block at line number in file string → statement ahead of the line in error. PCC-00004: Mismatched IF/ELSE/ENDIF block at line number in file string
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 "."
isNull() → Returns TRUE if the object pointed to by this ref is NULL else FALSE. Syntax bool isNull() const;
exists (OUT) → Is set to FALSE if the element at the specified index does not exist, else it is set to TRUE.
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.
validateElementContent → . Parameters: e - Element to be validated Returns: True if valid, else false
Exceptions → : Insufficient privilege to remove pipe. The pipe was created and is owned by someone else.
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;
schema_name (IN, optional) → must be all in upper-case, or else OCI throws an internal error and the program stops.
isSupported → by: isSupported in interface Node Returns: true,if the feature is supported else false