Pseudo is a value that is defined automatically by oracle for every table. It will not appear in the result of DESC Command and not stored within the table. It generally return a different value for each row in a table, there are two pseudo columns are commonly used.
- ROWNUM = system assigned no.of.rows, it is assigned before the ORDERBY clauses is processed.
- ROWID = system assigned physical address for given row, it will change time to time by database. ROWID useful for data in table where a problem exist.
Here ROWNUM is generated on employee table. result is displayed above.
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon