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 select unique values in sql?

981

---

What is %type in pl sql?

953

---

How many types of privileges are available in sql?

1334

---

What are sql functions? Describe in brief different types of sql functions?

1077

---

define sql update statement ? : Sql dba

1100

---

Why do we use procedures in sql?

1059

---

Is sql a scripting language?

975

---

What is rtm stands for?

1079

---

what is 'mysqldump'? : Sql dba

1093

---

Is drop table faster than truncate?

976

---

What do you mean by field in sql?

1069

---

What is package in pl sql with an examples?

1020

---

what is msql? : Sql dba

970

---

What is the difference between partition and index?

967

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7272

---