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 are the uses of sysdate and user keywords?

625

---

Explain the significance of the & and && operators in pl sql.

567

---

define join and explain different type of joins? : Sql dba

544

---

what is a unique key ? : Sql dba

541

---

What are aggregate functions in sql?

625

---

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

577

---

how to write date and time literals? : Sql dba

528

---

how to use 'mysql' to run sql statements? : Sql dba

537

---

What are the two types of exceptions in pl/sql?

541

---

what is log shipping? : Sql dba

609

---

What is meaning of <> in sql?

583

---

How do you declare a variable in pl sql?

533

---

What is dba in sql? : SQL DBA

533

---

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.

1643

---

How do I create a sql script?

538

---