Answers

Question and Answer:

  Home  Oracle PL-SQL

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

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

 172 views

More Questions for you: