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 IF


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


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

IF Statement

IF StatementThe 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

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 … 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

DML Reference, 10g Release 1 (10.1)

IF...THEN...ELSE

boolean-expressioncontinues 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

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

BFILE check if openThe 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"

Reference, 10g Release 1 (10.1)

Wait Event Descriptions

BFILE check if existsThe session waits to check if an external large object (LOB) exists. Wait Time: The total elapsed

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

4 Using PL/SQL Control Structures

Using the IF-THEN StatementThe 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

Concepts and Administration, 10g Release 1 (10.1)

5 Log Transport Services

5.5 What to Do If Errors Occurfailed 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

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

Broker, 10g Release 1 (10.1)

A D ata Guard Broker Changed and Deprecated Features

Deprecated Property Replacement Property (if any)Table A-3 Deprecated Properties Deprecated Property Replacement Property (if any) Alternate No

Concepts and Administration, 10g Release 1 (10.1)

10 Data Guard Scenarios

10.8.2 Determining If an Archive Gap ExistsTo 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

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

7 Advanced Topics for Oracle Objects

If a Type Change Validation Failsreferenced. 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.

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 … is false or , the ELSIF clause tests another condition. An IF statement can have any number

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

4 Using PL/SQL Control Structures

Testing Conditions: IF and CASE StatementsThe 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

Reference, 10g Release 1 (10.1)

TRUSTED_SERVERS

Condition (If. .. ) TRUSTED column NAME columnTable 3-3 TRUSTED_SERVERS Values Condition (If... ) TRUSTED column NAME column... all servers are

2 Day DBA, 10g Release 1 (10.1)

9 Performing Backup and Recovery

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

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

5 Using PL/SQL Collections and Records

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,

Concepts and Administration, 10g Release 1 (10.1)

10 Data Guard Scenarios

10.7.3 Determining If a Backup Is Required After Unrecoverable OperationsIf 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

DML Reference, 10g Release 1 (10.1)

5.2 Compiling Programs

5.2.1 Finding Out If a Program Has Been CompiledYou 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')

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

LOB Functions

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

SQL*Plus® User's Guide and Reference, 10g Release 1 (10.1)

3 Configuring SQL*Plus

Testing if the i SQL*Plus Application Server is RunningYou 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