Explian Rowid, Rownum? What Are The Psoducolumns We Have?

1.	Explian Rowid, Rownum? What Are The Psoducolumns We Have?
Answer» 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. 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.

Answer»

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.

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.

Discussion