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 |
Name the operator which is used in the query for pattern matching?
how do you know if your mysql server is alive? : Sql dba
Explain how can you save or place your msg in a table?
What do you understand by pl/sql records?
What is normalization sql?
Why is stored procedure faster than query?
Why is sharding used?
How to read/write files from pl/sql?
Differences between UNIQUE and DISTINCT in select statements
26 Answers ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,
how to write utl file pkg in SQL
Can we have two clustered index on a table?
PL/SQL allocates memory for the variable's at runtime or at compile time