Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the features and advantages of object-oriented programming? : Sql dba
what is unique key constraint? : Sql dba
What is varchar data type in sql?
Why query optimization is needed?
Can you selectively load only those records that you need? : aql loader
explain advantages of myisam over innodb? : Sql dba
how to select unique records from a table? : Sql dba
How can a function retun more than one value in oracle with proper example?
How to change sql*plus system settings?
What operators deal with null?
How do you change a value in sql?
What is a system versioned table?
What is asqueryable?
How to use boolean type in select statement?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
