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

how do you control the max size of a heap table? : Sql dba

993

---

Which is better join or subquery?

1151

---

What are records give examples?

1018

---

what are the 'mysql' command line arguments? : Sql dba

1150

---

How do I remove sql plus from windows 10?

1113

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1446

---

How much does sql certification cost?

1101

---

What is the use of %rowtype?

1048

---

Can sql developer connect to db2?

1058

---

Can unique keys be null?

918

---

How do you update a value in sql?

1058

---

How many commands are in sql?

1079

---

what is sql profiler? : Sql dba

1057

---

Is it possible to create the following trigger: before or after update trigger for each row?

1296

---

What is a common use of group by in sql?

1056

---