Answer Posted / amedela chandra sekhar
SQL> select * from (select rownum as rno,emp.* from emp)
2 where rno=&n;
Enter value for n: 2
old 2: where rno=&n
new 2: where rno=2
RNO EMPNO ENAME JOB MGR
HIREDATE SAL
---------- ---------- ---------- --------- ----------
--------- ----------
COMM DEPTNO
---------- ----------
2 7499 ALLEN SALESMAN 7698
20-FEB-81 1600
300 30
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you select unique values in sql?
What is %type in pl sql?
How many types of privileges are available in sql?
What are sql functions? Describe in brief different types of sql functions?
define sql update statement ? : Sql dba
Why do we use procedures in sql?
Is sql a scripting language?
What is rtm stands for?
what is 'mysqldump'? : Sql dba
Is drop table faster than truncate?
What do you mean by field in sql?
What is package in pl sql with an examples?
what is msql? : Sql dba
What is the difference between partition and index?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.