Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / phanikumar
to retrieve all the record at a time we use BULK COLLECT
but in cursors records will be retrieved one by one in loop. cursors an time taking process .
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is a database lock ? : Sql dba
What is sqlexception in java?
What is anonymous block in sql?
what is self-join? : Sql dba
What are actual parameters and formal parameters?
What is sql constant?
how to shut down the server with 'mysqladmin'? : Sql dba
What are the operators used in select statements?
What is the requirement of self-join?
What is recursive join in sql?
Can instead of triggers be used to fire once for each statement on a view?
Is pl sql still used?
What is trigger and stored procedure in sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
I need a function for a train ticket reservation please answer it thanks in advance
