Can we use the cursor's to create the collection in PL/SQL?

0 Answers   MCN Solutions,

---

PL/SQL allocates memory for the variable's at runtime or at compile time

3 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

how to create a primary key with out creating an index?

9 Answers   TCS,

---

What is sqlexception in java?

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---

What is sql query optimization?

0 Answers  

---

Explain ddl statements in pl/sql?

0 Answers  

---

Does sql*plus also have a pl/sql engine?

0 Answers  

---

How many triggers can be applied to a table?

0 Answers  

---

What is the need of a partition key?

0 Answers  

---

What are functions in sql?

0 Answers  

---