Answer Posted / dinesh mishra

Header (named module only)
Declaration (IS)
Execution (BEGIN)
Exception
END;

What is sql rowcount?

1028

---

Define join and name different types of joins?

1008

---

Can we perform dml in function?

1071

---

What is the difference between the conventional and direct path loader? : aql loader

1157

---

Mention what is the plv (pl/vision) package offers?

1107

---

Can we use having without group by in sql?

986

---

What are types of exception?

922

---

How do I pipe the output of one isql to another?

1007

---

What is on delete restrict?

1003

---

What does (+) mean in sql joins?

1071

---

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1069

---

What is the use of sqldataadapter?

976

---

what is cursor. write example of it. What are the attributes of cursor.

1395

---

What is the maximum number of triggers, you can apply on a single table?

998

---

what is the difference between primary key and unique key? : Sql dba

1039

---