Results for NOT


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


Database PL/SQL Language Reference, 11g Release 1 (11.1)

PL/SQL Language Fundamentals

Using NOT NULLA declaration can impose the NOT NULL constraint, which prevents you from assigning a value to … NOT NULL must also specify a default value. PL/SQL subtypes NATURALN, POSITIVEN, and SIMPLE_INTEGER … are predefined as NOT NULL. When declaring a variable of one of these subtypes, you can omit the NOT … NULL constraint,

Database Administrator's Guide, 11g Release 1 (11.1)

When to Use Hash Clusters

Situations Where Hashing Is Not AdvantageousHashing is not advantageous in the following situations: Most queries on the table retrieve rows … clause of a query can be found with relatively few I/Os. The table is not static, but instead is

Database SQL Language Reference, 11g Release 1 (11.1)

Logical Conditions

Table 7-5 NOT Truth Table-- TRUE FALSE UNKNOWN NOT FALSE TRUE UNKNOWN Table 7-6 shows the results of combining the AND condition to two expressions.

Text Reference, 11g Release 1 (11.1)

Oracle Text CONTAINS Query Operators

NOT (~)Use the NOT operator to search for documents that contain one query term and not another. Syntax … Syntax Description term1 ~ term2 term1 not term2 Returns documents that contain term1 and not term2 … . Examples To obtain the documents that contain the term animals but not dogs, use the following

Database Installation Guide for Linux, 11g Release 1 (11.1)

Troubleshooting

G.13 Online Help Not Workingthe images directory. If images in Oracle Application Express do not display correctly, you may … /images directory to the directory defined by the first /i/ alias. G.13 Online Help Not Working If … users are accessing Oracle Application Express through a Virtual Host, online Help will not work … example, Oracle Application Express

Database Data Warehousing Guide, 11g Release 1 (11.1)

Integrity Constraints

NOT NULL ConstraintsWhen using query rewrite, you should consider whether NOT NULL constraints are required. The … , \"Advanced Query Rewrite\" for further information regarding NOT NULL constraints when using query rewrite.

Database Concepts, 11g Release 1 (11.1)

Data Integrity

NOT NULL Integrity ConstraintsBy default, all columns in a table allow s. Null means the absence of a value. A NOT NULL … datatypes, when adding a column that has both a NOT NULL constraint and a default value, the database … , the database does not need to populate every row with the default value when you add the column … , thereby minimizing the time that

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing RMAN Tablespace Point-in-Time Recovery (TSPITR)

Special Considerations When Not Using a Recovery CatalogIf you do not use a recovery catalog when performing TSPITR, then note the following special … may not succeed if Oracle has reused the control file records for needed backups. (In planning your … tablespace, and then bring the tablespace online at time t. When not using a recovery catalog, the current

Database Data Warehousing Guide, 11g Release 1 (11.1)

Hardware and I/O Considerations in Data Warehouses

Configure I/O for Bandwidth not Capacitycan provide, and not necessarily on their overall storage capacity. Buying storage based solely on … in a fully-mirrored environment. However, six drives might not provide enough I/O bandwidth to handle … system. While it may not be practical to estimate the I/O bandwidth that will be required by a data

Database Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Troubleshooting the Oracle Database Installation

F.11 Online Help Not Workingcopied the images directory. If images in Oracle Application Express do not display correctly, you may … Not Working If users are accessing Oracle Application Express through a Virtual Host, online Help … will not work. Consider the following example: The host name of the Oracle HTTP Server where the … port 80. In this example,

Database Data Warehousing Guide, 11g Release 1 (11.1)

Using Parallel Execution

When Not to Implement Parallel ExecutionParallel execution is not normally useful for: Environments in which the typical query or … execution is not useful in these environments because there is a cost associated with coordinating the … such resources are available, then parallel execution will not yield any benefits and indeed may be detrimental to performance.

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Parameter class Not applicableImported? No Parameter class Not applicable

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

OCI: Introduction and Upgrading

OCI Routines Not SupportedSome OCI routines that were available in previous versions of OCI are not supported in later … releases. They are listed in Table 1-2, \"OCI Functions Not Supported\": Table 1-2 OCI Functions Not Supported

SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

SQL*Plus Error Messages

SP2-0640 Not connected.Cause: The string specified was too long. Action: Reduce the size of the specified string and re-try the operation. SP2-0640 Not connected.

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Corresponds to Not applicableStandby type Physical or logical Corresponds to Not applicable

Text Reference, 11g Release 1 (11.1)

Stopword Transformations in Oracle Text

H.1.6 NOT TransformationsStopword Expression Rewritten Expression non_stopword NOT stopword non_stopword non_stopword NOT … no_token non_stopword stopword NOT non_stopword no_token no_token NOT non_stopword no_token stopword … NOT stopword no_token no_token NOT stopword no_token stopword NOT

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Broker default Not applicableValid values A connect identifier that can be used to connect to this database Broker default Not applicable

Real Application Clusters Installation Guide for Linux and UNIX, 11g Release 1 (11.1)

Troubleshooting the Oracle Real Application Clusters Installation Process

YPBINDPROC_DOMAIN: Domain not boundAction: Ensure that all member nodes of the cluster have the same clock time. YPBINDPROC_DOMAIN: Domain not bound

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Corresponds to Not applicableStandby Type Physical or logical Corresponds to Not applicable

Database Security Guide, 11g Release 1 (11.1)

Configuring Authentication

Using Client Identifiers to Identify Application Users Not Known to the Databaseare users who are authenticated to the middle tier of an application, but who are not known to the … . Daniel is not a database user; he is a typical Web Expense application user. The application … access control. It does not have to be the application user name. To set the CLIENT_IDENTIFIER

Database Data Warehousing Guide, 11g Release 1 (11.1)

Advanced Query Rewrite

Query Rewrite Types Dimensions Primary Key/Foreign Key/Not Null ConstraintsMatching SQL Text Not Required Not Required Join Back Required OR Required Aggregate Computability … Not Required Not Required Aggregate Rollup Not Required Not Required Rollup Using a Dimension … Required Not Required Filtering the Data Not Required

Database Clusterware Administration and Deployment Guide, 11g Release 1 (11.1)

Oracle Clusterware Alert Messages

CRS-1008 Node %s is not responding to OCR requests. Details in %s.Node %s is not responding to OCR requests. Details in %s.

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableNote: Prior to Oracle Database release 11.1, the DGConnectIdentifier configurable database property was known as the InitialConnectIdentifier property. When upgrading a 10 g configuration to Oracle Database release 11.1, the InitialConnectIdentifier value will be retained as the new DGConnectIdentifier value for that database. If this is an Oracle RAC database, then before the upgrade, you must ensure

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Database Enterprise Manager name Not applicable See Also: Oracle Database PL/SQL Packages and Types Reference

Oracle C++ Call Interface Programmer's Guide, 11g Release 1 (11.1)

Object Programming

NOT INSTANTIABLE Types and MethodsA type can be declared NOT INSTANTIABLE, which means that there is no constructor (default or user … defined) for the type. Thus, it will not be possible to construct instances of this type. The … : CREATE TYPE Address_t AS OBJECT(...) NOT INSTANTIABLE NOT FINAL; CREATE TYPE USAddress_t UNDER … NOT

SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

SQL*Plus Error Messages

SP2-0023 String not foundCause: An internal error occurred. Action: Free up additional memory by: closing applications not … required; reducing the size of the command, or statement; or by recoding the query to select fewer records. SP2-0023 String not found

Pro*FORTRAN Supplement to the Oracle Precompilers Guide, 11g Release 1 (11.1)

Implementing Dynamic SQL Method 4

Handling Null/Not Null DatatypesFor every select-list column (not expression), DESCRIBE SELECT LIST returns a /not … constrained to be not , the high-order bit of SELT(J) is clear; otherwise, it is set. Before using the … select-list column. 1 means the column allows s; 0 means it does not. The following example shows … = 1, SELN * Find out

Oracle Call Interface Programmer's Guide, 11g Release 1 (11.1)

OCI Object-Relational Programming

NOT INSTANTIABLE Types and MethodsA type can be declared to be NOT INSTANTIABLE, which means that there is no constructor (default or … user defined) for the type. Thus, it will not be possible to construct instances of this type. The … used: CREATE TYPE Address_t AS OBJECT(...) NOT INSTANTIABLE NOT FINAL; CREATE TYPE USAddress_t UNDER … be NOT

Universal Installer and OPatch User's Guide for Windows and UNIX, 11g Release 1 (11.1)

Patching Oracle Software with OPatch

Not a valid patch areaCause: The directory that the OPatch utility is using to do the patch does not match the template … and the actions file under the same directory. If you did not start the OPatch utility from the

Pro*C/C++ Programmer's Guide, 11g Release 1 (11.1)

Oracle Dynamic SQL: Method 4

Handling NULL/Not NULL DatatypesFor every select-list column (not expression), DESCRIBE SELECT LIST returns a NULL/not NULL … to be not NULL, the high-order bit of T[ i ] is clear; otherwise, it is set. Before using the … datatype in an OPEN or FETCH statement, if the NULL/not NULL bit is set, you must clear it. (Never set the … find out if

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Instance Enterprise Manager name Not applicable

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Database Enterprise Manager name Not applicable

SQL*Plus User's Guide and Reference, 11g Release 1 (11.1)

SQL*Plus Error Messages

SP2-0046 column_name not definedCause: No columns have been defined. Action: No action required. SP2-0046 column_name not defined

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Database Enterprise Manager name Not applicable

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Database Enterprise Manager name Not applicable

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Database Enterprise Manager name Not applicable

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Database Enterprise Manager name Not applicable

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Instance Enterprise Manager name Not applicable

Pro*COBOL Programmer's Guide, 11g Release 1 (11.1)

Oracle Dynamic SQL: Method 4

Handling NULL/Not NULL DatatypesFor every select-list column (not expression), DESCRIBE SELECT LIST returns a NULL/not NULL … be not NULL, the high-order bit of SELDVTYP(J) datatype variable is clear; otherwise, it is set … the column allows NULLs; 0 means that it does not. The following example shows how to use SQLNUL … -NULLS VARYING J FROM

Data Guard Broker, 11g Release 1 (11.1)

Database Properties

Enterprise Manager name Not applicableScope Instance Enterprise Manager name Not applicable





Was this page helpful?

Integrated Cloud Applications & Platform Services