Answer Posted / kiran r
Cursor is is pointer which is used access data retrived from database.Cursor is static in nature
ref cursor is datatype variable. whose memory address is working area query in database. it is dynamic in nature and it can be modified at the runtime
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we use %rowtype & %type in plsql?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
Is sql a dbms?
How would you reference column values before and after you have inserted and deleted triggers?
How many types of normalization are there?
what is a materialized view? : Sql dba
What are stuff and replace function?
what are the differences between char and varchar? : Sql dba
How do I run a sql query in pgadmin 4?
Can a key be both primary and foreign?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What are the different types of tables in sql?
what is a join? : Sql dba
What is pl sql quora?
What if we write return in procedure?