Answer Posted / saswati
select a.*
from(select e.*,rownum sl_no
from emp e) a
where a.sl_no = 2
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain lock escalation? : Transact sql
Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?
In pl/sql, what is bulk binding, and when/how would it help performance?
what is sql? : Sql dba
Does oracle roll back the transaction on an error?
What is the purpose of using pl/sql?
Is sql low level language?
How run sql*plus commands that are stored in a local file?
How do I edit a stored procedure?
What is a record in pl/sql?
What is the limitation on the block size of pl/sql?
What are the topics in pl sql?
Is oracel sql developer written in java?
Does truncate free space?
What are string functions in sql?