Difference between revisions of "ROWID"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
| (2 intermediate revisions by the same user not shown) | |||
| 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 | ||
| − | |||
==Syntax== | ==Syntax== | ||
ROWID | ROWID | ||
| − | |||
==See Also== | ==See Also== | ||
[[PSEUDO COLUMNS]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | [[PSEUDO COLUMNS]], [[SQL INSERT|INSERT]], [[SQL SELECT|SELECT]], [[SQL UPDATE|UPDATE]] | ||
| − | |||
==Description== | ==Description== | ||
| Line 15: | Line 12: | ||
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. | 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== | ==Example== | ||
| Line 23: | Line 19: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
| − | |||
Latest revision as of 09:52, 4 February 2013
Contents
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
