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

Which one is better subquery or joins?

1008

---

What types of commands can be executed in sql*plus?

1049

---

What are the different tcl commands in sql?

1102

---

How do I install sql?

939

---

How to add new employee details in an employee_details table with the following details

1043

---

What is left inner join in sql?

985

---

What is the advantage of nosql?

994

---

What is before and after trigger?

890

---

Where is pl sql used?

903

---

What is the difference between inner join and outer join?

929

---

What are all ddl commands?

1013

---

What is a table partition?

1036

---

Why we use stored procedure instead of query?

950

---

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

---

tell us something about heap tables. : Sql dba

1047

---