Results for EXISTS


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


Database SQL Language Reference, 11g Release 2 (11.2)

EXISTS Condition

EXISTS ConditionAn EXISTS condition tests for existence of rows in a subquery. Description of the illustration … ''exists_condition.gif'' Table 7-11 shows the EXISTS condition. Table 7-11 EXISTS Condition Type of … Condition Operation Example EXISTS TRUE if a subquery returns at least one row. SELECT department_id … FROM departments

OLAP DML Reference, 11g Release 2 (11.2)

EXISTS

name-expressionName When name-expression contains multiple object names, EXISTS returns NO even when all the objects … specified by name-expression exist in attached workspaces. Examples Example 7-79 Using EXISTS This … SHOW EXISTS('actual') produces the following result. YES

OLAP DML Reference, 11g Release 2 (11.2)

EXISTS

EXISTSThe EXISTS function determines whether an object is defined in any attached workspace. The EXISTS … function is useful in a program to test whether a definition exists before you try to use it. Return … Value BOOLEAN Syntax EXISTS( name-expression ) Parameters

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Collections and Records

EXISTS Collection MethodEXISTS is a function that tells you whether the specified element of a varray or nested table … exists. EXISTS( n ) returns TRUE if the n th element of the collection exists and FALSE otherwise. If n … is out of range, EXISTS returns FALSE instead of raising the predefined exception … SUBSCRIPT_OUTSIDE_LIMIT.

Application Express Application Builder User's Guide, 11g Release 2 (11.2)

Understanding Page Processing and Page Rendering

Exists(SQL query returns at least one row) is expressed as a SQL query. If the query returns at least one row, then the condition evaluates as true. For example: SELECT 1 FROM employees WHERE department_id =:P101_DEPTNO This example references item P101_DEPTNO as a bind variable. You can use bind variables within application processes and SQL query regions to reference item session state. If one or more

Objects for OLE Developer's Guide for Microsoft Windows, 11g Release 2 (11.2)

Exists Property

Exists PropertyApplies To OraBFILE Object Description Returns True if the OraBFILE points to a BFILE that exists … on the database. Usage exists = OraBFile.Exists Data Type Boolean Remarks Read privileges on the … ( scott ) can read a directory ( BfileDirectory ) through the Exists property, the following SQL

Database Reference, 11g Release 2 (11.2)

Descriptions of Wait Events

BFILE check if existsThe session waits to check if an external large object (LOB) exists. Wait Time: The total elapsed … time for the exists call Parameter Description session# See \"session#\" waited See \"waited\"

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Duplicating a Database: Advanced Topics

Duplicating a Database When No Server Parameter File ExistsThe procedure in \"Step 5: Creating an Initialization Parameter File and Starting the Auxiliary Instance\" assumes that you use the SPFILE clause of the DUPLICATE command. If the source database does not use a server parameter file, then you must set all necessary parameters for the auxiliary instance in a text-based initialization parameter file. Table 25-5 describes a subset of the possible initialization

Database Backup and Recovery User's Guide, 11g Release 2 (11.2)

Duplicating a Database: Advanced Topics

Starting the Auxiliary Instance When No Server Parameter File Exists\"Step 5: Creating an Initialization Parameter File and Starting the Auxiliary Instance\" assumes that the source database instance uses a server parameter file. This scenario assumes that the source database does not currently use a server parameter file or RMAN cannot restore a backup server parameter file. In this case, you must start the auxiliary instance with a text-based initialization parameter

Warehouse Builder Data Modeling ETL, and Data Quality Guide,, 11g Release 2 (11.2)

Activities in Process Flows

File ExistsUse the File Exists activity to verify the existence of a file before running the next activity. In … The File Exists activity checks only once. If the file exists, then the process flow proceeds with … transition. The File Exists activity triggers the error transition only in a catastrophic failure such … as

Application Express Application Builder User's Guide, 11g Release 2 (11.2)

Using Collections

Verifying Whether a Collection ExistsUse COLLECTION_EXISTS to determine if a collection exists, for example: l_exists:= APEX_COLLECTION.COLLECTION_EXISTS ( p_collection_name => collection name );

R Enterprise User's Guide for Windows, Linux, Solaris, and AIX, 11g Release 2 (11.2)

Using Oracle R Enterprise

Verify that an ore.frame Existsore.exists() returns TRUE if the object exists in the ORE schema and FALSE, if it does not exist.

Database Upgrade Guide, 11g Release 2 (11.2)

Upgrading to the New Release of Oracle Database

To check if a standby database exists and to synchronize it Issue the following query: SQL> SELECT SUBSTR(value,INSTR(value,'=',INSTR(UPPER(value),'SERVICE'))+1) FROM v$parameter WHERE name LIKE 'log_archive_dest%' AND UPPER(value) LIKE 'SERVICE%'; If the query in the previous step returns a row, then synchronize the standby database with the primary database. Make sure all the logs are transported to the standby server after a final log switch in the primary.

TimesTen In-Memory Database SQL Reference, 11g Release 2 (11.2)

Search Conditions

EXISTS predicateAn EXISTS predicate checks for the existence or nonexistence of a table subquery. The predicate … evaluates to TRUE if the subquery returns at least one row for EXISTS or returns no rows for NOT EXISTS … . SQL syntax [NOT] EXISTS (Subquery) Parameters The EXISTS predicate has the following parameter

Grid Infrastructure Installation Guide for IBM AIX on POWER Systems (64-Bit), 11g Release 2 (11.2)

Advanced Installation Oracle Grid Infrastructure for a Cluster Preinstallation Tasks

2.4.1 Determining If the Oracle Inventory and Oracle Inventory Group Existsthe oraInst.loc file exists, then the output from this command is similar to the following … confirm that the group specified as the Oracle Inventory group still exists on the system. For example: $ grep oinstall /etc/group oinstall:x:1000:grid,oracle

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0540 File file_name already exists. Use SAVE filename[.ext] REPLACEcommand for the correct options. SP2-0540 File file_name already exists. Use SAVE filename[.ext] REPLACE

Grid Infrastructure Installation Guide for Oracle Solaris, 11g Release 2 (11.2)

Advanced Installation Oracle Grid Infrastructure for a Cluster Preinstallation Tasks

2.4.1 Determining If the Oracle Inventory and Oracle Inventory Group Exists/oraInst.loc If the oraInst.loc file exists, then the output from this command is similar to the following … /group to confirm that the group specified as the Oracle Inventory group still exists on the system

Grid Infrastructure Installation Guide for HP-UX, 11g Release 2 (11.2)

Advanced Installation Oracle Grid Infrastructure for a Cluster Preinstallation Tasks

2.4.1 Determining If the Oracle Inventory and Oracle Inventory Group Existsexists, then the output from this command is similar to the following: inventory_loc=/u01/app/oracle

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0605 File file_name already exists. Use another name or STORE {SET} filename[.ext] REPLACEcommand for the correct options. SP2-0605 File file_name already exists. Use another name or STORE {SET} filename[.ext] REPLACE

Grid Infrastructure Installation Guide for Linux, 11g Release 2 (11.2)

Advanced Installation Oracle Grid Infrastructure for a Cluster Preinstallation Tasks

2.5.1 Determining If the Oracle Inventory and Oracle Inventory Group Existsthe oraInst.loc file exists, then the output from this command is similar to the following … confirm that the group specified as the Oracle Inventory group still exists on the system. For example: $ grep oinstall /etc/group oinstall:x:1000:grid,oracle

SQL*Plus User's Guide and Reference, 11g Release 2 (11.2)

SQL*Plus Error Messages

SP2-0771 File filename already exists. Use another name or \"SPOOL filename[.ext] REPLACE\"filename already exists. Use another name or \"SPOOL filename[.ext] REPLACE\"

Database Enterprise User Security Administrator's Guide, 11g Release 2 (11.2)

Using the User Migration Utility

Attribute exists : : orclPasswordinterface table for a T/F value that correctly reflects whether a database password exists for this user.

Database SQL Language Reference, 11g Release 2 (11.2)

About SQL Conditions

Table 7-1 SQL Condition PrecedencePrecedence\" =, !=,, =, comparison IS [NOT] NULL, LIKE, [NOT] BETWEEN, [NOT] IN, EXISTS, IS OF type

Database Semantic Technologies Developer's Guide, 11g Release 2 (11.2)

Jena Adapter for Oracle Database

7.14.1 BOUND or !BOUND Instead of EXISTS or NOT EXISTSFor better performance, use BOUND or !BOUND instead of EXISTS or NOT EXISTS.

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Creating a Directorydirectory ALTER DISKGROUP data ADD DIRECTORY '+data/orcl'; Assuming no subdirectory exists under the

Database SQL Language Reference, 11g Release 2 (11.2)

Joins

SemijoinsA semijoin returns rows that match an EXISTS subquery without duplicating rows from the left side

Database SQL Language Reference, 11g Release 2 (11.2)

Conditions

7 ConditionsBETWEEN Condition EXISTS Condition IN Condition IS OF type Condition

Database Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle Scheduler

A Window Fails to Take Effectthe end of its schedule A window that points to a schedule that no longer exists is disabled See

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Using Oracle ASM Filenames in SQL Statementsthe Oracle ASM file exists, then you must use the reference form of the filename, and if you are

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

ASMCMD Volume Management Commands

Option Descriptionvolume also prevents any subsequent opens on the volume or device file because it no longer exists

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Distributed Transactions

Naming Transactionsexists, it is ignored when a transaction name exists. The transaction name is displayed in the NAME

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Collections and Records

Collection Methodsa collection, EXISTS is the only collection method that does not raise the predefined exception … Procedure Adds elements to end of varray or nested table. EXISTS Function Returns TRUE if and only … if specified element of varray or nested table exists. FIRST Function Returns first index in … Method TRIM Collection Method EXTEND

Database Administrator's Guide, 11g Release 2 (11.2)

Using Oracle Managed Files

Renaming Filesexists, then it is deleted. You must specify each filename using the conventions for filenames on your operating system when you issue this statement.

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Administering Oracle ASM Files, Directories, and Templates

Alias Oracle ASM Filename with Template Formgroup data to contain the alias name and that the user-defined template exists. Example 7-1 Creating a

Database Administrator's Reference for HP OpenVMS Itanium, 11g Release 2 (11.2)

Messages and Codes

ORA-07522:sfccf: new file existsCause: A file that was not designated as REUSE already exists. Action: Add REUSE to the file specification or delete the existing file.

Database Administrator's Reference for HP OpenVMS Itanium, 11g Release 2 (11.2)

Messages and Codes

ORA-07546:sfcmf: new file existsCause: The file name of a file to be added resolved to that of a file already in the database. Action: Change the file name of the file to be added.

Automatic Storage Management Administrator's Guide, 11g Release 2 (11.2)

Introduction to Oracle ACFS

Oracle ACFS Taggingas no switch exists to save Extended Attributes. To use Oracle ACFS tagging functionality on Linux

Database PL/SQL Language Reference, 11g Release 2 (11.2)

Collection Method Invocation

Collection Method Invocation\"Predefined PLS_INTEGER Subtypes\" ). EXISTS Function that returns TRUE if the index th element of the … collection exists and FALSE otherwise, explained in \"EXISTS Collection Method\". EXTEND Procedure that … exists. Otherwise, NEXT returns NULL. For more information, see \"PRIOR and NEXT Collection Methods

Database SQL Language Reference, 11g Release 2 (11.2)

PRESENTNNV

PRESENTNNVrule. It returns expr1 when cell_reference exists prior to the execution of the model_clause and is … sales for the Mouse Pad for the year 2002 exists, and the sales value is not , then the sales … value remains unchanged. If the row exists and the sales value is , then the sales value is set to

Database PL/SQL Language Reference, 11g Release 2 (11.2)

PL/SQL Packages

Creating SERIALLY_REUSABLE Packagesspecification and, if it exists, the package body. Example 10-4 creates two very simple SERIALLY_REUSABLE





Was this page helpful?

Integrated Cloud Applications & Platform Services