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 1270 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

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

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

SET CONSTRAINT[S]

SET CONSTRAINT[S]deferrable constraint is checked following each DML statement ( IMMEDIATE ) or when the transaction is … committed ( DEFERRED ). You can use this statement to set the mode for a list of constraint names or … . Prerequisites To specify when a deferrable constraint is checked, you must have SELECT privilege … on the table to which

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

Managing Schema Objects

Integrity Constraint StatesYou can specify that a constraint is enabled ( ENABLE ) or disabled ( DISABLE ). If a constraint is … conform to the constraint is prevented from being entered. If a constraint is disabled, then data that … in the table must conform to the constraint ( VALIDATE ). Conversely, if you specify NOVALIDATE

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

Managing Schema Objects

Deferring Constraint ChecksWhen the database checks a constraint, it signals an error if the constraint is not satisfied. You … until another SET CONSTRAINTS statement resets the mode. Notes: You cannot issue a SET CONSTRAINT … applies only to the current transaction. The defaults specified when you create a constraint remain … as long

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

Managing Schema Objects

Viewing Constraint InformationOracle Database provides the following views that enable you to see constraint definitions on … ALL_CONSTRAINTS USER_CONSTRAINTS DBA view describes all constraint definitions in the database. ALL view … describes constraint definitions accessible to current user. USER view describes constraint

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

PL/SQL Language Fundamentals

NOT NULL ConstraintYou can impose the NOT NULL constraint on a scalar variable or constant (or scalar component of a … composite variable or constant). The NOT NULL constraint prevents assigning a value to the item … . The item can acquire this constraint either implicitly (from its data type) or explicitly. A scalar … Example 2-13, the variable

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

Managing Schema Objects

Reporting Constraint ExceptionsIf exceptions exist when a constraint is validated, an error is returned and the integrity … constraint remains novalidated. When a statement is not successfully executed because integrity constraintconstraint until all exceptions to the constraint are either updated or deleted. To determine which

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

Managing Indexes

Creating an Index Associated with a ConstraintOracle Database enforces a UNIQUE key or PRIMARY KEY integrity constraint on a table by creating a … when the constraint is enabled. No action is required by you when you issue the CREATE TABLE or ALTER … exercise control over its creation. This includes both when a constraint is defined and enabled, and when a … defined but disabled

Database Concepts, 11g Release 2 (11.2)

Data Integrity

Examples of Constraint Checkingconstraint makes entries in the manager_id column dependent on the values of the employee_id column … manager_id column does not have a NOT NULL constraint defined on it. Because s are allowed in foreign … Database performs its constraint checking after the statement has been completely run. To allow a row … row has 300 for employee

Database Data Warehousing Guide, 11g Release 2 (11.2)

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

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Constraint States RELY NORELY… Rewrite will then work for example in TRUSTED mode. ALTER VIEW time_view ADD (CONSTRAINT time_view_pk … PRIMARY KEY (time_id) DISABLE NOVALIDATE); ALTER VIEW time_view MODIFY CONSTRAINT time_view_pk RELY … ; ALTER TABLE sales ADD (CONSTRAINT time_view_fk FOREIGN KEY (time_id) REFERENCES time_view(time_id … ) DISABLE

Database Concepts, 11g Release 2 (11.2)

Data Integrity

Table 5-2 Referential Integrity Constraint Termsconstraint that reference a referenced key. For example, the department_id column in employees is a foreign

Multimedia DICOM Developer's Guide, 11g Release 2 (11.2)

Creating DICOM Configuration Documents

10.2.2 Creating Constraint Documentsinformation about the DICOM value locator type. 10.2.2 Creating Constraint Documents Constraint … documents define one or more constraint rules. The XML schema ordcmct.xsd defines the XML schema that … constrains constraint documents. (See Section B.2 for a listing of the constraint document schema

Database Data Warehousing Guide, 11g Release 2 (11.2)

Advanced Query Rewrite

Table 19-1 Dimension and Constraint Requirements for Query Rewritethroughout this chapter. Table 19-1 Dimension and Constraint Requirements for Query Rewrite Query Rewrite

Database Concepts, 11g Release 2 (11.2)

Glossary

integrity constraintDeclarative method of defining a rule for a column. The integrity constraints enforce business rules and prevent the entry of invalid information into tables.

Database Concepts, 11g Release 2 (11.2)

Glossary

deferrable constraintA constraint that permits a SET CONSTRAINT statement to defer constraint checking until after the … transaction is committed. A deferrable constraint enables you to disable the constraint temporarily … while making changes that might violate the constraint.

Multimedia DICOM Developer's Guide, 11g Release 2 (11.2)

What's New in Oracle Multimedia DICOM?

Recursive Calls within Constraint DefinitionsOracle Multimedia DICOM now supports recursive calls within constraint definitions. See Section

Multimedia DICOM Developer's Guide, 11g Release 2 (11.2)

Creating DICOM Configuration Documents

10.1.2 Characteristics of Constraint DocumentsConstraint documents have these characteristics: No other document types depend on constraint … documents. There may be dependencies between constraint documents. Constraint documents depend on the … of constraint documents in the repository. Constraint documents can be written in such

Multimedia DICOM Developer's Guide, 11g Release 2 (11.2)

Overview of DICOM Administration

9.8.1 Deleting Anonymity, Mapping, and Constraint DocumentsFor anonymity documents and mapping documents, the order of deletion is irrelevant. Constraint

Data Guard Concepts and Administration, 11g Release 2 (11.2)

Managing a Logical Standby Database

10.7.1 Create a Primary Key RELY Constraintcertain the rows are unique, then create a primary key RELY constraint. On the logical standby database … OWNER, TABLE_NAME FROM DBA_LOGSTDBY_UNSUPPORTED; You can add a rely primary key constraint to a … table on the primary database, as follows: Add the primary key rely constraint at the primary database