Answer Posted / chandra bhusan prasad

one is supported in 8i and another in 9i/10g
cost base optimizer display the cost attributes of query
and it is easier.

What is the difference between join and natural join?

653

---

What is dialect in sql?

700

---

What is difference between pls_integer and integer?

707

---

What are the different type of joins in sql?

720

---

Can I call a procedure inside a function?

734

---

---

What are the types of views in sql?

745

---

Is vs as in pl sql?

670

---

What is function and procedure?

756

---

is mysql query is case sensitive? : Sql dba

772

---

Can a composite key be null?

711

---

Is pl sql and postgresql same?

767

---

What are the different parts of a package?

810

---

how to drop an existing table in mysql? : Sql dba

756

---

what is difference between delete and truncate commands? : Sql dba

803

---

How to run sql statements with oracle sql developer?

789

---