Answer Posted / anil_abbireddy

A table is created with in the table is called nested table

what is the difference between inner and outer join? Explain with example. : Sql dba

970

---

what is oltp (online transaction processing)? : Sql dba

1010

---

Explain aggregate functions are available there in sql?

938

---

Is it possible to read/write files to-and-from PL/SQL?

1033

---

What is row_number () in sql?

929

---

What is the use of procedures?

923

---

Can function return multiple values in sql?

982

---

Explain the the delete statements in sql?

974

---

What is asqueryable?

902

---

How to read/write files from pl/sql?

989

---

What is composite data type in pl sql?

1029

---

What is the difference between syntax error and runtime error?

1064

---

What is where clause in sql?

979

---

what are the different type of sql's statements ? : Sql dba

871

---

What will you get by the cursor attribute sql%notfound?

1011

---