Answer Posted / debanjan rudra

pl/sql collections are temporary table types which helps
the programmer to "temporary" manipulate data comprising
more than 1 row (i.e. not scalar).

Eg. CREATE OR REPLACE TAB AS TABLE OF VARCHAR2(100) INDEX
BY PLS_INTEGER;

In the above example "TAB" is a collection which shall be
used to temporarily store more than 1 varchar2 records.

What is sql not null constraint?

1093

---

What is bind variable in pl sql?

1104

---

Why do we use procedures?

1006

---

in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.

2135

---

What is audit logout in sql profiler?

1073

---

What version is sql?

1076

---

How delete all data from all tables in sql?

985

---

What is pls_integer in pl sql?

1157

---

What is the use of & in pl sql?

1096

---

What are sql*plus environment variables?

1155

---

How many sql commands are there?

1158

---

What do you mean by table in sql?

1045

---

What are the types of join in sql?

1147

---

which types of join is used in sql widely? : Sql dba

1030

---

How can check sql version from command line?

1136

---