How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
IF Statement → The IF statement executes or skips a sequence of statements, depending on the value of a Boolean … expression. For more information, see "Testing Conditions: IF and CASE Statements". Syntax Description … , greater-than, or less-than. The sequence following the THEN keyword is executed only if the expression … returns TRUE. ELSE
IF...THEN...ELSE → The IF...THEN...ELSE command executes one or more commands in a program when a specified condition … is not met. You can use IF only within programs. You can also use IF as a conditional operator in an … expression. See "IF as a Conditional Operator". Syntax IF boolean-expression THEN statement1
boolean-expression → continues with the statement after the whole IF...THEN... command in the program. Notes IF with DO … You can use the IF command for conditional execution of two or more statements by following the THEN … or ELSE (or both) keywords with a DO... DOEND sequence. See Example 14-13, "Using IF...THEN...ELSE … ". IF
BFILE check if open → The session waits for an external large object (LOB) to open. Wait Time: The total elapsed time for the isopen call Parameter Description session# See "session#" waited See "waited"
BFILE check if exists → The session waits to check if an external large object (LOB) exists. Wait Time: The total elapsed
Using the IF-THEN Statement → The simplest form of IF statement associates a condition with a sequence of statements enclosed by … the keywords THEN and END IF (not ENDIF ): IF condition THEN sequence_of_statements END IF; The … sequence of statements is executed only if the condition is true. If the condition is
5.5 What to Do If Errors Occur → failed destination. Use the REOPEN attribute to determine if and when the ARC n process or the LGWR … specified number of consecutive attempts is exceeded, the destination is treated as if the NOREOPEN
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
Deprecated Property Replacement Property (if any) → Table A-3 Deprecated Properties Deprecated Property Replacement Property (if any) Alternate No
10.8.2 Determining If an Archive Gap Exists → To determine if there is an archive gap, query the V$ARCHIVED_LOG and V$LOG views. If an archive … files in the archive gap. If there is no archive gap for a given thread, the query returns no rows
If a Type Change Validation Fails → referenced. If a type cannot be revalidated, it remains invalid, and any tables referencing it become … latest type version: you do not have the option to postpone conversion of the data.) If a table is … type version. If the table fails the revalidation, then compiling any program units that reference that table will also fail.
Using the IF-THEN-ELSIF Statement → ELSEIF 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 … is false or , the ELSIF clause tests another condition. An IF statement can have any number
Testing Conditions: IF and CASE Statements → The IF statement executes a sequence of statements depending on the value of a condition. There are … three forms of IF statements: IF-THEN, IF-THEN-ELSE, and IF-THEN-ELSIF. The CASE statement is a
Condition (If. .. ) TRUSTED column NAME column → Table 3-3 TRUSTED_SERVERS Values Condition (If... ) TRUSTED column NAME column... all servers are
Note: As explained in "Configuring Your Database for Basic Backup and Recovery", you can only use online… → set of objects to back up. Enter your host operating system credentials if required, and click … if your database is set up to run in ARCHIVELOG mode. Under the Advanced section, if this is an … and does not require media recovery if you restore from this backup.) For now, leave the option for … generated for
Checking If a Collection Element Exists (EXISTS Method) → EXISTS(n) returns TRUE if the n th element in a collection exists. Otherwise, EXISTS(n) returns … TABLE OF INTEGER; n NumList:= NumList(1,3,5,7); BEGIN n.DELETE(2); -- Delete the second element IF … n.EXISTS(1) THEN dbms_output.put_line('OK, element #1 exists.'); END IF; IF n.EXISTS(2) = FALSE THEN … dbms_output.put_line('OK,
10.7.3 Determining If a Backup Is Required After Unrecoverable Operations → If you performed unrecoverable operations on your primary database, determine if a new backup … recent invalidated redo data. Issue the following SQL statement on the primary database to determine if … -yyyy hh:mi:ss') FROM V$DATAFILE; If the query in the previous step reports an unrecoverable time
5.2.1 Finding Out If a Program Has Been Compiled → You can use the ISCOMPILED choice of the OBJ function to determine whether a specific program in your analytic workspace has been compiled since the last time it was modified. The function returns a Boolean value. SHOW OBJ(ISCOMPILED 'myprogram')
changed_lenp (OUT) Length of the new buffer, if provided. → csid (IN) The character set ID of the data in the buffer. If this value is 0 then csid is set to
Testing if the i SQL*Plus Application Server is Running → You can use operating system utilities to determine if the i SQL*Plus Application Server is running … from a Windows command prompt. UNIX: To determine if the i SQL*Plus Application Server is running … process is the i SQL*Plus Application Server. Windows Service: To determine if the i SQL*Plus Application … service to see whether