State the advatage and disadvantage of Cursor's?
Answers were Sorted based on User's Feedback
Answer / shilpa.oracle
Advantage:
Using cursors we can retrieve multiple records in a plsq block.
Disadvantage:
switching between the plsql statement executor and sql
statement executor at plsql runtime engine will consume time.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / swapna
advantage :
In pl/sql if you want perform some actions more than one
records you should user these cursors only. By using these
cursors you process the query records. you can easily move
the records and you can exit from procedure when you
required by using cursor attributes.
disadvantage:
using implicit/explicit cursors are depended by Situation.
If the result set is les than 50 or 100 records it is
better to go for implicit cursors. if the result set is
large then you should use exlicit cursors. other wise it
will put burdon on cpu.
| Is This Answer Correct ? | 5 Yes | 1 No |
can i give user defined exception in a package
what's the difference between a primary key and a unique key? : Sql dba
what is the different between unique+not null & primary key,
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
A table was given with 3 columns like Manager id,Manager Name and Employee name. Question was to create hierarchy.
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Can we rollback truncate?
What can be a size of a pl/sql block? Is there any limit?
Regarding joins what are the differences you observed in oracle 9i and sql server?
What are sql queries used for?
How can we implement rollback or commit statement in a trigger?
How do I remove sql plus from windows 10?
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)