Results for UNIQUE


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


Security Guide, 10g Release 1 (10.1)

12 Introducing Database Security for Application Developers

Unique Schemasdatabase and access the database objects. However, unique schemas do not allow connections to the database

Guide, 10g Release 1 (10.1)

2 Logical Design in Data Warehouses

Unique IdentifiersUnique identifiers are specified for one distinct record in a dimension table. Artificial unique … identifiers are often used to avoid the potential problem of unique identifiers changing. Unique

Guide, 10g Release 1 (10.1)

22 SQL for Modeling

Unique Dimensions Versus Unique Single Referencesdata is not unique. Uniqueness of the input rowset on the PARTITION BY and DIMENSION BY keys … optional UNIQUE DIMENSION keyword in the MODEL clause to make this behavior explicit. For example, the … ') MODEL UNIQUE DIMENSION PARTITION BY (country) DIMENSION BY (product) MEASURES (sales sales) IGNORE … violation error as the rowset

Concepts, 10g Release 1 (10.1)

5 Schema Objects

Unique and Nonunique IndexesIndexes can be unique or nonunique. Unique indexes guarantee that no two rows of a table have … column values. Oracle recommends that unique indexes be created explicitly, and not through enabling … a unique constraint on a table. Alternatively, you can define UNIQUE integrity constraints on the

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 … ) have been added to contain information relating to Workspace Manger support for unique constraints

Concepts, 10g Release 1 (10.1)

21 Data Integrity

UNIQUE Key Integrity ConstraintsA UNIQUE key integrity constraint requires that every value in a column or set of columns (key) be … unique—that is, no two rows of a table have duplicate values in a specified column or set of columns … . For example, in Figure 21-3 a UNIQUE key constraint is defined on the DNAME column of the dept … table to disallow rows with

Concepts, 10g Release 1 (10.1)

21 Data Integrity

Unique Constraints and IndexesA user sees inconsistent constraints, including duplicates in unique indexes, when that user's … transaction produces these inconsistencies. You can place deferred unique and foreign key constraints on … materialized views, allowing fast and complete refresh to complete successfully. Deferrable unique … constraint. Not-deferrable

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

1 Introduction to Workspace Manager

1.9.2 Unique ConstraintsTables with unique constraints defined on them can be version-enabled. The following are supported … : UNIQUE constraint on a single column or multiple columns Unique index on a single column or … multiple columns Functional unique index on the table The treatment of values is the same for version … metadata

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

3 Workspace Manager Valid Time Support

3.7.2 Unique ConstraintsIf a unique constraint exists in a version-enabled table with valid time support, the valid time … table has an EMPLOYEE_ID column that has a unique constraint. If an insert or update operation would

Concepts, 10g Release 1 (10.1)

5 Schema Objects

Index Unique ScanIndex unique scan is one of the most efficient ways of accessing data. This access method is used … for returning the data from B-tree indexes. The optimizer chooses a unique scan when all columns of a … unique (B-tree) index are specified with equality conditions.

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDAudio Object Type Relational Interface

ctxThe format plug-in context information. audioBfile The audio data represented as a BFILE. attributes The CLOB to hold the XML attribute information generated by the getProperties( ) method. This CLOB is populated with an extensive set of format and application properties of the audio BFILE data in XML form. mimeType The MIME type of the audio data. format The format of the audio data. If a non-NULL

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDDoc Object Type Relational Interface

getProperties( ) (all attributes) for BFILEsFormat getProperties(ctx IN OUT RAW, docBfile IN OUT NOCOPY BFILE, attributes IN OUT NOCOPY CLOB, mimeType OUT VARCHAR2, format IN OUT VARCHAR2, contentLength OUT INTEGER); Description Reads the document BFILE data to get the values of the media attributes for supported formats, and then stores them in the input CLOB and returns them as explicit parameters. This method gets the properties for the

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDVideo Object Type Relational Interface

ctxThe format plug-in context information. videoBfile The video data represented as a BFILE. attributes The CLOB to hold the XML attribute information generated by the getProperties( ) method. This CLOB is populated with an extensive set of format and application properties of the video BFILE data in XML form. format The format of the video data. If a non-NULL value is specified, then the format plug-in

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfileThe image data represented as a BFILE. attributes The CLOB to hold the XML attribute information generated by the getProperties( ) method. This CLOB is populated with a set of format properties of the image BFILE data in XML form. Usage Notes None. Pragmas None. Exceptions ORDImageExceptions.NULL_CONTENT This exception is raised when the imageBfile parameter is NULL. Examples Get the property information

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDVideo Object Type Relational Interface

ctxThe format plug-in context information. videoBlob The video data represented as a BLOB. attributes The CLOB to hold the XML attribute information generated by the getProperties( ) method. This CLOB is populated with an extensive set of format and application properties of the video BLOB data in XML form. mimeType The MIME type of the video data. format The format of the video data. If a non-NULL value

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDDoc Object Type Relational Interface

getProperties( ) for BFILEsFormat getProperties(ctx IN OUT RAW, docBfile IN OUT NOCOPY BFILE, attributes IN OUT NOCOPY CLOB, format IN VARCHAR2); Description Reads the document BFILE data to get the values of the media attributes, and then stores them in the input CLOB. It populates the CLOB with an extensive set of format and application properties in XML form. Parameters

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBfileThe image data represented as a BFILE. command A list of image processing changes to make for the image in the new copy. dest The destination of the new image. Usage Notes See Table 6-1, "Image Processing Operators" and Table 6-2, "Additional Image Processing Operators for Raw Pixel and Foreign Images". Calling this method processes the image into the destination BLOB from any source BFILE. The processCopy(

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDAudio Object Type Relational Interface

Static Methods Unique to the ORDAudio Object Type Relational InterfaceThis section presents reference information on the inter Media static methods unique to the

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDAudio Object Type Relational Interface

ctxThe format plug-in context information. audioBlob The audio data represented as a BLOB. attributes The CLOB to hold the XML attribute information generated by the getProperties( ) method. This CLOB is populated with an extensive set of format and application properties of the audio BLOB data in XML form. mimeType The MIME type of the audio data. format The format of the audio data. If a non-NULL value

Reference, 10g Release 1 (10.1)

Static Methods Unique to the ORDImage Object Type Relational Interface

imageBlobThe image data represented as a BLOB. command A list of image processing operations to perform on the image. Usage Notes You can change one or more of the image attributes shown in Table 6-1. Table 6-2 shows additional changes that can be made only to raw pixel and foreign images. See Appendix D for more information on process( ) operators. The process( ) method changes image attributes, therefore


Was this page helpful?