Interested to Buy Any Domain ? << Click Here >> for more details...
what are pl/sql collections?
- 4 Answers
- 32135 Views
- JPMorgan Chase, Oracle, I also Faced
- E-Mail Answers
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.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
How does a self join work?
Explain exception handling in pl/sql?
Is microsoft sql free?
What are different types of sql commands?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
Why we use triggers in mysql?
what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba
Mention what does plv msg allows you to do?
Does inner join remove duplicates?
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the difference between instead of trigger and after trigger?
What do you understand by exception handling in pl/sql?
What are the various levels of constraints?
What are the types of queries in sql?
What is sql resultset?
