Oracle PL-SQL Question:

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

Oracle PL-SQL Interview Question
Oracle PL-SQL Interview Question

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


Previous QuestionNext Question
What is difference b/w stored procedures and application procedures, stored function and application function?what is the starting oracle error number?
what is meant by forward declaration in functions?