Oracle PL-SQL Interview Question:

Explian rowid, rownum?what are the psoducolumns we have?

Submitted by: Administrator

ROWID - Hexa decimal number each and every row having unique.Used in searching.

ROWNUM - It is a integer number also unique for sorting Normally TOP N Analysys.

Other Psudo Column are

NEXTVAL,CURRVAL Of sequence are some exampls

psudo columns are default columns provided by oracle
Submitted by: Administrator