Results for WHERE


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


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

Managing Hash Clusters

Situations Where Hashing Is Usefulcluster key: SELECT... WHERE cluster_key =...; In such cases, the cluster key in the equality

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

Sequence Pseudocolumns

Where to Use Sequence Valuesoperator The WHERE clause of a SELECT statement The DEFAULT value of a column in a CREATE TABLE or

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

Managing Hash Clusters

Situations Where Hashing Is Not Advantageousequivalent of a full table scan must be done to fetch the rows for the query. SELECT... WHERE cluster_key … With an index, key values are ordered in the index, so cluster key values that satisfy the WHERE

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

Managing Tablespaces

Scenario 3: Fixing Bitmap Where Overlap is ReportedThe TABLESPACE_VERIFY procedure reports some overlapping. Some of the real data must be sacrificed based on previous internal errors. After choosing the object to be sacrificed, in this case say, table t1, perform the following tasks: Make a list of all objects that t1 overlaps. Drop table t1. If necessary, follow up by calling the SEGMENT_DROP_CORRUPT procedure. Call the SEGMENT_VERIFY procedure

Database Security Guide, 11g Release 2 (11.2)

Using Application Contexts to Retrieve User Information

Where Are the Application Context Values Stored?Oracle Database stores the application context values in a secure data cache available in the User Global Area (UGA) or the System (sometimes called \"Shared\") Global Area (SGA). This way, the application context values are retrieved during the session. Because the application context stores the values in this data cache, it increases performance for your applications. You can use an application

Database Security Guide, 11g Release 2 (11.2)

Verifying Security Access with Auditing

Where Are Fine-Grained Audit Records Stored?Fine-grained audit records are stored in the SYS.FGA_LOG$ table. To find the records have been generated for the audit policies that are in effect, you can query the DBA_FGA_AUDIT_TRAIL data dictionary view. The DBA_COMMON_AUDIT_TRAIL data dictionary view combines both standard and fine-grained audit log records. In addition, you can query the V$XML_AUDIT_TRAIL view to find fine-grained audit records

Database Security Guide, 11g Release 2 (11.2)

Using Oracle Virtual Private Database to Control Data Access

Creating a Function to Generate the Dynamic WHERE ClauseTo generate the dynamic WHERE clause (predicate), you must create a function (not a procedure) that … provide a return value for the WHERE clause predicate that will be generated. The return value for the … WHERE clause is always a VARCHAR2 data type. It must generate a valid WHERE clause. This code can be … that

Database Upgrade Guide, 11g Release 2 (11.2)

Introduction to the Upgrade Process for Oracle Database

Where to Find the Latest Information About Upgrading Oracle DatabaseOracle provides late-breaking updates, discussions, and best practices about pre-upgrade, post-upgrade, compatibility, and interoperability on the My Oracle Support Web site at https://support.oracle.com. You can search on note IDs or key words like \"Database Upgrade.\" For the complete knowledge base and latest information about patch sets, go to My Oracle Support at https://support.oracle.com and

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Host Tables

The WHERE ClauseWHERE JOB =:JOB-TITLE END-EXEC. were treated like the following statement PERFORM VARYING I FROM 1 BY … 1 UNTIL I = 50 SELECT MGR INTO:MGR-NUMBER(I) FROM EMP WHERE JOB =:JOB_TITLE(I) END-EXEC END … -PERFORM. because multiple rows might meet the WHERE-clause search condition, but only one output variable … be ambiguous if the statement

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Host Arrays

Using the WHERE ClauseEXEC SQL SELECT mgr INTO:mgr_number FROM emp WHERE job =:job_title; were treated like the imaginary … statement for (i = 0; i because multiple rows might meet the WHERE-clause search condition, but only … other hand, it would not be ambiguous if the statement EXEC SQL UPDATE emp SET mgr =:mgr_number WHERE … empno IN (SELECT empno

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Embedded SQL

The WHERE ClauseUse the WHERE clause to SELECT, UPDATE, or DELETE only those rows in a table or view that meet your … search condition. The WHERE-clause search condition is a Boolean expression, which can include … functions. If you omit the WHERE clause, all rows in the table or view are processed. If you omit the … WHERE clause

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Embedded SQL

Using the WHERE ClauseYou use the WHERE clause to select, update, or delete only those rows in a table or view that meet … your search condition. The WHERE-clause search condition is a Boolean expression, which can include … scalar host variables, host arrays (not in SELECT statements), and subqueries. If you omit the WHERE … clause, all rows in the

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Host Arrays

SET Clause WHERE Clause Valid?array array yes scalar scalar yes array scalar no scalar array no

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 2 (11.2)

Implementing Dynamic SQL Method 4

Where Is the Information Stored?the addresses of these data buffers in a select or bind SQLDA, so that Oracle knows where to write

XML DB Developer's Guide, 11g Release 2 (11.2)

Accessing Oracle XML DB Repository Data

Where Is Repository Data Stored?Oracle XML DB stores Oracle XML DB Repository data in a set of tables and indexes to which you have access. If you register an XML schema and request that the tables be generated by Oracle XML DB, then the tables are created in your database schema. You are then able to see or modify them. Other users cannot see your tables unless you grant them permission to do so. Names of Generated Tables The names

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

The Object Type Translator

Where OTT Parameters Can AppearSupply OTT parameters on the command line, in a CONFIG file named on the command line, or both. Some parameters are also allowed in the INTYPE file. OTT is invoked as follows: OTT username/password parameters If one of the parameters on the command line is CONFIG= filename additional parameters are read from the configuration file named filename. In addition, parameters are also read from a default

Pro*COBOL Programmer's Guide, 11g Release 2 (11.2)

Host Tables

SET Clause WHERE Clause Valid?table table yes scalar scalar yes table scalar no scalar table no

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Host Arrays

INTO Clause WHERE Clause Valid?array array no scalar scalar yes array scalar yes scalar array no

Oracle C++ Call Interface Programmer's Guide, 11g Release 2 (11.2)

Object Type Translator Utility

Where OTT Parameters Can AppearSCHEMA_NAMES Parameter in OTT Utility Consider an example where the SCHEMA_NAMES parameter is set to … to connect to the default database as user OPS$username, where username is the user's operating … system username. Where OTT Parameters Can Appear Supply OTT parameters on the command line, in a CONFIG

Pro*C/C++ Programmer's Guide, 11g Release 2 (11.2)

Oracle Dynamic SQL: Method 4

Where Is the Information Stored?that Oracle knows where to write output values and read input values. How do values get stored in





Was this page helpful?

Integrated Cloud Applications & Platform Services