Results for ROWID


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


SQL Reference, 10g Release 1 (10.1)

ROWID

ROWIDFor each row in the database, the ROWID pseudocolumn returns the address of the row. Oracle … Database rowid values contain information necessary to locate a row: The data object number of the object … to the tablespace. Usually, a rowid value uniquely identifies a row in the database. However, rows in … different tables that

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

3 Datatypes

ROWID DescriptorThe ROWID datatype identifies a particular row in a database table. ROWID can be a select-list item … in a query, such as: SELECT ROWID, ename, empno FROM emp In this case, you can use the returned … ROWID in further DELETE statements. If you are performing a SELECT for UPDATE, the ROWID is implicitly

Performance Tuning Guide, 10g Release 1 (10.1)

14 The Query Optimizer

Rowid ScansThe rowid of a row specifies the datafile and data block containing the row and the location of the … row in that block. Locating a row by specifying its rowid is the fastest way to retrieve a single … row, because the exact location of the row in the database is specified. To access a table by rowid … the table based on its rowid.

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

2 OCI Programming Basics

ROWID DescriptorThe ROWID descriptor, OCIRowid, is used by applications that need to retrieve and use Oracle ROWIDs … . To work with a ROWID using OCI release 8 or later, an application can define a ROWID descriptor … for a rowid position in a SQL select-list, and retrieve a ROWID into the descriptor. This same

Concepts, 10g Release 1 (10.1)

26 Native Datatypes

The ROWID PseudocolumnEach table in an Oracle database internally has a pseudocolumn named ROWID. This pseudocolumn is … , each row's address can be retrieved with a SQL query using the reserved word ROWID as a column name … , for example: SELECT ROWID, last_name FROM employees; You cannot set the value of the pseudocolumn … ROWID

Utilities, 10g Release 1 (10.1)

11 Conventional and Direct Path Loads

Loading ROWID ColumnsIn both conventional path and direct path, you can specify a text value for a ROWID column. (This … is the same text you get when you perform a SELECT ROWID FROM table_name operation.) The character … string interpretation of the ROWID is converted into the ROWID type for a column in a table.

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

A New Features

A.3.7 Universal ROWIDThe support for universal ROWID datatype is presented. Index-organized tables use this concept. See "Universal ROWIDs".

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

10 Oracle Extensions

10.5.1 Oracle ROWID TypeA ROWID is an identification tag unique for each row of an Oracle database table. The ROWID can be … supplied as a wrapper for type ROWID SQL data. ROWIDs provide functionality similar to the getCursorName … the java.sql.Statement interface. If you include the ROWID pseudo-column in a query, then you can … column

Oracle® C++ Call Interface Programmer's Guide, 10g Release 1 (10.1)

4 Datatypes

Universal Rowid (UROWID)The universal rowid ( UROWID ) is a datatype that can store both the logical and the physical rowid … . Logical rowid values are primary key-based logical identifiers for the rows of index organized tables … set to 8.1 or higher. The following OCCI_SQLT types can be bound to universal rowid s: OCCI_SQLT_CHR

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

2 Selecting a Datatype

Addressing Rows Directly with the ROWID DatatypeEvery row in an Oracle Database table is assigned a ROWID that corresponds to the physical address … of a row. If the row is too large to fit within a single data block, the ROWID identifies the … initial row piece. Although ROWID s are usually unique, different rows can have the same ROWID if they are … pseudocolumn

Concepts, 10g Release 1 (10.1)

26 Native Datatypes

Overview of ROWID and UROWID DatatypesOracle uses a ROWID datatype to store the address ( rowid ) of every row in the database. Physical … universal rowid, or UROWID, supports both logical and physical rowids, as well as rowids of foreign tables

Application Developer's Guide - Object-Relational Features, 10g Release 1 (10.1)

8 Design Considerations for Oracle Objects

Speeding up Object Access Using the WITH ROWID OptionIf the WITH ROWID option is specified for a REF column, Oracle maintains the rowid of the object … referenced in the REF. Then, Oracle can find the object referenced directly using the rowid contained … in the REF, without the need to fetch the rowid from the OID index. Therefore, you use the WITH … ROWID

Pro*C/C++ Programmer's Guide, 10g Release 1 (10.1)

E System-Specific References

E.1.5 Size of an Integer and ROWIDThe size in bytes of integer datatypes and the binary external size of ROWID datatypes are system dependent. See "INTEGER " and "ROWID".

SQL Reference, 10g Release 1 (10.1)

Datatype Comparison Rules

CHAR VARCHAR2 NCHAR NVARCHAR DATE DATETIME/INTERVAL NUMBER BINARY_FLOAT BINARY_DOUBLE LONG RAW ROWID…NUMBER BINARY_FLOAT BINARY_DOUBLE LONG RAW ROWID CLOB BLOB NCLOB CHAR — X X X X X X X X X X — X … X — — — — — X — — — X — ROWID X X X X — — — — — — — — — — — CLOB X X X X — — — — — X — — X — X BLOB … datatypes, Oracle converts from any character datatype to a numeric, date, or rowid, as appropriate

Error Messages, 10g Release 1 (10.1)

8 ORA-09870 to ORA-12100

ORA-10632: Invalid rowidCause: It is incorrect to issue shrink on the object Action: Verify the object name and type and reissue the command ORA-10632: Invalid rowid

Concepts and Administration, 10g Release 1 (10.1)

4 Creating a Logical Standby Database

BFILEROWID UROWID

SQL Reference, 10g Release 1 (10.1)

Datatype Comparison Rules

to CHAR,VARCHAR2,NCHAR,NVARCHAR2 to NUMBER to Datetime/Interval to RAW to ROWID to LONG,LONG RAW to…/Interval to RAW to ROWID to LONG,LONG RAW to CLOB, NCLOB,BLOB to BINARY_FLOAT to BINARY_DOUBLE from CHAR … TO_TIMESTAMP_TZ TO_YMINTERVAL TO_DSINTERVAL HEXTORAW CHARTO­=ROWID — TO_CLOB TO_NCLOB TO_BINARY_FLOAT … ) — — — — — — — — from RAW RAWTOHEX RAWTONHEX — — — — — TO_BLOB — — from ROWID ROWIDTOCHAR

SQL Reference, 10g Release 1 (10.1)

CAST

from BINARY_FLOAT, BINARY_DOUBLE from CHAR, VARCHAR2 fromNUMBER from DATETIME / INTERVAL Note 1 fromRAW…fromNUMBER from DATETIME / INTERVAL (Note 1) fromRAW from ROWID, UROWID (Note 2) from NCHAR, NVARCHAR2 to … DATE, TIMESTAMP, INTERVAL — X — X — — — to RAW — X — — X — — to ROWID, UROWID — X — — — X a — to NCHAR … TIMEZONE, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH. Note 2: You cannot cast a UROWID to a ROWID … if the

Reference, 10g Release 1 (10.1)

8 CTX_DOC Package

key_type Specify either ROWID or PRIMARY_KEY as the input key type document identifier for CTX_DOC procedures.…Example To set CTX_DOC procedures to accept primary key document identifiers, do the following: begin ctx_doc.set_key_type('PRIMARY_KEY'); end

Packages and Types Reference, 10g Release 1 (10.1)

90 DBMS_SQL

SyntaxDBMS_SQL.LAST_ROW_ID RETURN ROWID;





Was this page helpful?

Integrated Cloud Applications & Platform Services