Interested to Buy Any Domain ? << Click Here >> for more details...
We have a CURSOR then we need BULK COLLECT?
- 1 Answers
- 3609 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 |
Explain isolation levels. : Transact sql
What is %s in sql?
How do I view a view in sql?
How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra
What is posting?
What is a sql profiler?
What is the max nvarchar size?
How does stored procedure reduce network traffic?
How many tables can you join in sql?
What is sqlexception in java?
What is information schema in sql?
What are the benefits of triggers?
-
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)
