Interested to Buy Any Domain ? << Click Here >> for more details...
We have a CURSOR then we need BULK COLLECT?
- 1 Answers
- 3603 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the disadvantages of file system?
what is oltp (online transaction processing)? : Sql dba
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
Can we write create command in the plsql block?if possible how?
What does the hierarchical profiler does?
Does sql view stored data?
How do I quit sql?
What are all the ddl commands?
What are the types of variable use in pl sql?
What is use of package in pl sql?
What is integrity constraints?
What is a sql instance vs database?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
