How do I display row number with records?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

58. How do I display row number with records?

Answer1
To achive this use rownum pseudocolumn with query, like SQL> SQL> select rownum, ename from emp;
Output:
1 Scott
2 Millor
3 Jiyo
4 Smith

Answer2
select rownum ,ename from emp;
Output:
1 smith
2 john
3 king
4 scott

(Continued on next question...)

Other Job Interview Questions

• What are the different approaches used by Optimizer in choosing an execution plan?
• You have just compiled a PL/SQL package but got errors, how would you view the errors?
• What is Parallel Server?
• What are parameters?
• What does the term panel refer to with regarda to pages?
• What is the use of image_zoom built-in?
• What is the difference between object embedding and linking in Oracle forms?
• Compare and contrast TRUNCATE and DELETE for a table.
• Is the After report trigger fired if the report execution fails?
• What are the types of calculated columns available?
• More...