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
What's the procedure?
Which is faster joins or subqueries?
What is pls integer?
What is a sql*loader control file?
How do you optimize a stored procedure in sql?
How to rename a column in the output of sql query?
How to take user input in pl sql?
what is error ora-03113: end-of-file on communication channel?
Explain the components of sql?
What is the difference between a primary key and a clustered index?
Can we commit in trigger?
What is interval partition?
Is sql free?
Why stored procedures are faster than query?
what is the command line end user interface - mysql? : Sql dba