Answer Posted / harsha vardhan reddy
CURSOR is a temporary workspace area used to hold
transaction data.
It is valid in PLSQL only.
It is not stored in database.
It cannot be reuse.
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How is it different from a normal table?
How to drop an existing table in oracle?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
How to convert dates to characters in oracle?
How to Truncate Table in Oracle
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
How to invoke the data pump import utility?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are transaction isolation levels supported by oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is a procedure in oracle?
Does oracle database need java?
What are the differences between date and timestamp in oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is the difference between view and materialized view in Oracle?