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 CONSTRAINT


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


SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Foreign Key Constraintsof TIMESTAMP WITH LOCAL TIME ZONE. The referenced unique or primary key constraint on the parent … child or parent object is a view, then the constraint is subject to all restrictions on view … constraints. See "View Constraints". You cannot define a foreign key constraint in a CREATE TABLE … statement that contains an AS subquery

SQL Reference, 10g Release 1 (10.1)

constraint

constraintPurpose Use a constraint to define an integrity constraint— a rule that restricts the values in a … ways. The six types of integrity constraint are described briefly here and more fully in "Semantics … ": A NOT NULL constraint prohibits a database value from being . A unique constraint prohibits

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Primary Key Constraints A table or view can have only one primary key. None of the columns…Foreign Key Constraints A foreign key constraint (also called a referential integrity constraint … . You can define a foreign key constraint on a single key column either inline or out of line. You must … composite foreign key constraint, the composite foreign key must refer to a composite unique key or a

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on the using_index_clause You cannot specify this clause for a view constraint. You cannot…Handling Constraint Exceptions When defining the state of a constraint, you can specify a table … into which Oracle places the rowids of all rows violating the constraint. exceptions_clause Use the

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on the exceptions_clause You cannot specify this clause for a view constraint. You cannot…view using the WITH CHECK OPTION clause, which is equivalent to specifying a check constraint for the … keywords DISABLE NOVALIDATE when you declare the view constraint, and you cannot specify any other mode … (other constraints are not shown): CREATE TABLE promotions_var1 ( promo_id NUMBER(6) CONSTRAINT … ), promo_begin_date

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Unique Constraints None of the columns in the unique key can be of LOB, LONG, LONG RAW,…Primary Key Constraints A primary key constraint designates a column as the primary key of a table … define a primary key constraint inline, you need only the PRIMARY KEY keywords. When you define a … primary key constraint out of line, you must also specify one or more columns. You must define a … composite primary key out of

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Scope ConstraintsYou cannot add a scope constraint to an existing column unless the table is empty. You cannot … specify a scope constraint for the REF elements of a VARRAY column. You must specify this clause if you … constraint from a REF column. Rowid REF Constraints Specify WITH ROWID to store the rowid along … Rowid Constraints You cannot

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Foreign Key Constraints on REF ColumnsOracle implicitly adds a scope constraint when you add a referential integrity constraint to an … . Specifying Constraint State As part of constraint definition, you can specify how and when Oracle should … enforce the constraint. constraint_state You can use the constraint_state with both inline and

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on Check Constraints You cannot specify a check constraint for a view. However, you can…SCOPE REF Constraints In a table with a REF column, each REF value in the column can conceivably reference a row in a different object table. The SCOPE clause restricts the scope of references to a single table, scope_table. The values in the REF column or attribute point to objects in scope_table, in which object instances of the same type as the REF column are stored. Specify the SCOPE clause to

SQL Reference, 10g Release 1 (10.1)

constraint

Restrictions on NOT NULL Constraints You cannot specify NULL or NOT NULL in a view constraint. You cannot…Unique Constraints A unique constraint designates a column as a unique key. A composite unique key … designates a combination of columns as the unique key. When you define a unique constraint inline … , you need only the UNIQUE keyword. When you define a unique constraint out of line, you must also … constraint,

Concepts, 10g Release 1 (10.1)

21 Data Integrity

Constraint StatesENABLE ensures that all incoming data conforms to the constraint DISABLE allows incoming data … , regardless of whether it conforms to the constraint VALIDATE ensures that existing data conforms to the … constraint NOVALIDATE means that some existing data may not conform to the constraint In addition … : ENABLE

Concepts, 10g Release 1 (10.1)

21 Data Integrity

Constraint Attributesinitially immediate. These attributes can be different for each constraint. You specify them with … keywords in the CONSTRAINT clause: DEFERRABLE or NOT DEFERRABLE INITIALLY DEFERRED or INITIALLY … constraint's attributes. See Also: Oracle Database SQL Reference for information about constraint … attributes and their default values

SQL Reference, 10g Release 1 (10.1)

SET CONSTRAINT[S]

SET CONSTRAINT[S]deferrable constraint is checked following each DML statement or when the transaction is committed … . Prerequisites To specify when a deferrable constraint is checked, you must have SELECT privilege on the … table to which the constraint is applied unless the table is in your schema. Syntax set_constraints … ::= Description of

Concepts, 10g Release 1 (10.1)

21 Data Integrity

Constraint State ModificationYou can use the MODIFY CONSTRAINT clause of the ALTER TABLE statement to change the following … constraint states: DEFERRABLE or NOT DEFERRABLE INITIALLY DEFERRED or INITIALLY IMMEDIATE RELY or NORELY … Database SQL Reference for information about these constraint states

Application Developer's Guide - Workspace Manager, 10g Release 1 (10.1)

New and Changed Features

Unique Constraint SupportTables with several kinds of unique constraints and indexes on them are supported for version-enabled tables, as explained in Section 1.9.2. The following metadata views (described in Chapter 5 ) have been added to contain information relating to Workspace Manger support for unique constraints: ALL_WM_CONSTRAINTS and USER_WM_CONSTRAINTS ALL_WM_IND_COLUMNS and USER_WM_IND_COLUMNS ALL_WM_IND_EXPRESSIONS

Guide, 10g Release 1 (10.1)

7 Integrity Constraints

Overview of Constraint Statesbasic purposes of constraints. Some of these purposes are: Enforcement In order to use a constraint for … enforcement, the constraint must be in the ENABLE state. An enabled constraint ensures that all … modification operations which produce data that violates the constraint fail with a constraint violation

Concepts, 10g Release 1 (10.1)

21 Data Integrity

Deferred Constraint CheckingYou can defer checking constraints for validity until the end of the transaction. A constraint is … deferred if the system checks that it is satisfied only on commit. If a deferred constraint is … violated, then commit causes the transaction to undo. If a constraint is immediate (not deferred), then it … immediately. If a constraint

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

C XPath and Namespace Primer

Namespace Constraint: Prefix Declarednamespace bindings and is not itself bound to any namespace name. This constraint may lead to

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

3 Maintaining Data Integrity Through Constraints

Deferring Constraint ChecksWhen Oracle Database checks a constraint, it signals an error if the constraint is not satisfied … of a transaction. Note: You cannot issue a SET CONSTRAINT statement inside a trigger. The SET … Guidelines for Deferring Constraint Checks Select Appropriate Data You may wish to defer constraint checks

Application Developer's Guide - Fundamentals, 10g Release 1 (10.1)

3 Maintaining Data Integrity Through Constraints

Fixing Constraint ExceptionsWhen you try to create or enable a constraint, and the statement fails because integrity constraint … exceptions exist, the statement is rolled back. You cannot enable the constraint until all … exceptions are either updated or deleted. To determine which rows violate the integrity constraint, include … : Oracle