rowid

The rowid is the physical address of a given row in the database. It is unique, but has no other meaning. Specifically, it can change by exporting the table and reimporting it. It is also not ordered. That is, because of the way ORACLE loads data into tables and the database, there is no guarantee that the largest rowid is the 'last'row. Relational databases are designed based on set theory, where order doesn't count and is unreliable, unless and ORDER BY clause is used in the Select statement.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 02 1998 - 00:00:00 CST