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 ROWID


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


SQL Reference, 9i Release 2 (9.2.0.2)

Basic Elements of Oracle SQL, 6 of 10

ROWIDFor each row in the database, the ROWID pseudocolumn returns a row's address. Oracle9 i rowid … ). The file number is relative to the tablespace. Usually, a rowid value uniquely identifies a row in the … the same rowid. Values of the ROWID pseudocolumn have the datatype ROWID or UROWID.

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

ROWIDROWNUM

User's Guide, 9i Release 2 (9.2.0.2)

Job and Event Scripts

rowidThe Oracle database rowid of an existing row, and must be in the format of an Oracle rowid datatype.

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

New Features

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

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Introduction to the 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, 9i Release 2 (9.2.0.2)

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

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_ROWID, 1 of 2

ROWID TypesThe types are as follows: RESTRICTED --restricted ROWID EXTENDED --extended ROWID For example … ROWIDs are only used in Oracle8 i and higher. ROWID Verification Results Result Description VALID … Valid ROWID INVALID Invalid ROWID For example: rowid_is_valid constant integer:= 0; rowid_is_invalid

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Programming Basics

ROWID DescriptorThe ROWID descriptor, OCIRowid, is used by applications that need to retrieve and use Oracle ROWIDs … . The size and structure of the ROWID has changed from Oracle release 7 to Oracle release 8, and is … opaque to the user. To work with a ROWID using OCI release 8 or later, an application can define a … ROWID

SQLJ Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Type Support

Support for Oracle ROWIDThe Oracle-specific type ROWID stores the unique address for each row in a database table. The … class oracle.sql.ROWID wraps ROWID information and is used to bind and define variables of type ROWID … the following declarations: #sql iterator NamedRowidIter (String ename, ROWID rowid); #sql iterator

Concepts, 9i Release 2 (9.2.0.2)

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

Concepts, 9i Release 2 (9.2.0.2)

Native Datatypes

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

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

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 … VARCHAR ) OCCI_SQLT_AFC ( CHAR) OCCI_SQLT_AVC ( CHARZ ) OCCI_SQLT_VST (string) OCCI_SQLT_RDD (ROWID descriptor)

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Overview of Oracle Extensions

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

Migration, 9i Release 2 (9.2.0.2)

Upgrading an Oracle7 Database Using the MIG Utility

ROWID Migration and Compatibility IssuesFor backward compatibility, the restricted form of the ROWID is still supported. These ROWIDs exist … in massive amounts of Oracle7 data, and the extended form of the ROWID is required only in global … 8.0 and Higher Client The ROWID values that are returned are always restricted ROWIDs. Also, ROWID … values returned

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Selecting a Datatype

Addressing Rows Directly with the ROWID DatatypeEvery row in an Oracle 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 in the … pseudocolumn

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

System-Specific References

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".

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

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

User's Guide, 9i Release 2 (9.2.0.2)

Job and Event Scripts

logon-handle rowid table column filename See "Common Parameters". Comments orawritelong composes andexecutes an SQL update statement based on the table, column, and rowid. orawritelong returns a … formatted ROWID may be obtained through a prior execution of the orasql function, such as "SELECT … rowid FROM table WHERE....". orawritelong raises a Tcl error if the logon-handle specified is not … open, or if rowid,

User's Guide, 9i Release 2 (9.2.0.2)

Job and Event Scripts

logon-handle rowid table column filename See "Common Parameters" .. Comments orareadlong returns a decimalraises a Tcl error if the logon-handle specified is not open, or if rowid, table, or column are invalid … the table, column, and rowid. A properly formatted Rowid may be obtained through a prior execution of orasql, such as "SELECT rowid FROM table WHERE...".

Error Messages, 9i Release 2 (9.2.0.2)

ORA-00900 to ORA-01499

ORA-01410 invalid ROWIDCause: A ROWID was entered incorrectly. ROWIDs must be entered as formatted hexadecimal strings … using only numbers and the characters A through F. A typical ROWID format is '000001F8.0001.0006 … '. Action: Check the format, then enter the ROWID using the correct format. ROWID format: block ID, row in block, file ID.