Answer Posted / jprakash025

select * from emp
minus
select * from emp
where
rownum<=(select count(*)-10 from emp);

or



SQL> select * from
2 (select rownum a, emp.* from emp)
3 where
4 a>(select max(rownum)-10 from emp);

Differentiate between pl/sql and sql?

1073

---

How do I view output in sql developer?

1029

---

Mention what does the hierarchical profiler does?

1023

---

What is the primary use of normalization?

944

---

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

972

---

What does the argument [or replace] do?

1017

---

Can you rollback after commit?

936

---

What is aggregate function in sql?

988

---

Explain the difference between rename and alias?

966

---

Enlist the data types that can be used in pl/sql?

1014

---

Define implicit and explicit cursors.

1076

---

What is minus?

940

---

Can we commit in trigger?

923

---

What is pl sql code?

995

---

Does truncate release storage space?

1015

---