Oracle PL-SQL Question:

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

Download Oracle PL-SQL PDF Read All 52 Oracle PL-SQL Questions

Previous Question	Next 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?