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

Can we use threading in pl/sql?

1036

---

what are wild cards used in database for pattern matching ? : Sql dba

1137

---

How does index help in query performance?

1028

---

What is the purpose of primary key?

1018

---

how to calculate expressions with sql statements? : Sql dba

1032

---

Is coalesce faster than isnull?

966

---

Can a foreign key be null?

1078

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3567

---

Why use stored procedures?

1081

---

Can a key be both primary and foreign?

991

---

How delete all records from table in sql?

977

---

How much does sqlite cost?

1033

---

What is sql select statement?

1028

---

what is the difference between join and union? : Sql dba

1111

---

Why is sharding used?

993

---