How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- 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
constraint → Purpose 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
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
Integrity Constraint States → You 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
Deferring Constraint Checks → When 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
Viewing Constraint Information → Oracle 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
NOT NULL Constraint → You 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
Reporting Constraint Exceptions → If 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 constraint … constraint until all exceptions to the constraint are either updated or deleted. To determine which
Creating an Index Associated with a Constraint → Oracle 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
Examples of Constraint Checking → constraint 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
Overview of Constraint States → basic 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
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
Table 5-2 Referential Integrity Constraint Terms → constraint that reference a referenced key. For example, the department_id column in employees is a foreign
10.2.2 Creating Constraint Documents → information 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
Table 19-1 Dimension and Constraint Requirements for Query Rewrite → throughout this chapter. Table 19-1 Dimension and Constraint Requirements for Query Rewrite Query Rewrite
integrity constraint → Declarative method of defining a rule for a column. The integrity constraints enforce business rules and prevent the entry of invalid information into tables.
deferrable constraint → A 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.
Recursive Calls within Constraint Definitions → Oracle Multimedia DICOM now supports recursive calls within constraint definitions. See Section
10.1.2 Characteristics of Constraint Documents → Constraint 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
9.8.1 Deleting Anonymity, Mapping, and Constraint Documents → For anonymity documents and mapping documents, the order of deletion is irrelevant. Constraint
10.7.1 Create a Primary Key RELY Constraint → certain 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