ROWID

Purpose

Return a number identifying the row’s physical stored position in the table

Syntax

ROWID

See Also

PSEUDO COLUMNS, INSERT, SELECT, UPDATE

Description

A Pseudo Column behaves like a table column, but is not actually stored in the table. You can select from Pseudo Columns, but they can not be updated. Pseudo Columns provide extra information about a SELECT row set.

The ROWID Pseudo Column will return a number identifying the row’s physical stored position in the table. The ROWID Pseudo Column can be used to perform singleton selects, or optimize updates of a known ROWID.

Example

// Optimized update accounts row 35 with a 15% commission charge
UPDATE accounts SET ord_value=ord_value*1.15, due_date = date()+30 WHERE ROWID=35

Products

Recital, Recital Server