Answer Posted / subhani

some of above have used corelated subqueries but it is not
recommonded to use.
best way is
select * from emp where rownum<=5
minus
select * from emp where rownum<5;

What are character functions?

1073

---

What is difference between procedure and trigger?

962

---

What is memory optimized table?

1030

---

What is a record in pl/sql?

1126

---

How do I run pl sql in sql developer?

1099

---

Why do we use cursors?

976

---

How can you load multi line records? : aql loader

1065

---

explain the difference between myisam static and myisam dynamic. : Sql dba

927

---

What does desc stand for?

1058

---

What is the difference between jpql and sql?

1074

---

Can one improve the performance of sql*loader? : aql loader

1026

---

Explain how exception handling is done in advance pl/sql?

985

---

Can we write dml inside a function in sql server?

930

---

What are the different schemas objects that can be created using pl/sql?

1004

---

What is difference between stored procedures and application procedures?

994

---