Difference between revisions of "ROWID"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Return a number identifying the row’s physical stored position in the table | Return a number identifying the row’s physical stored position in the table | ||
Revision as of 14:56, 29 October 2009
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 EXEC SQL UPDATE accounts SET ord_value=ord_value*1.15, due_date = date()+30 WHERE ROWID=35;
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
