How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3182 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
OPEN cursor variable FOR SELECT...Statement
CLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is set verify off in oracle?
What is the difference between formal parameters and actual parameters?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
Is oracle an open source?
How to delete an existing row from a table in oracle?
What is recovery manager in Oracle?
Can sub procedure/function be called recursively?
What is oracle open database communication (odbc)?
What is the meaning of recursive hints in oracle?
Give the advantages and disadvantages of clusters.
What is meant by a deadlock situation?
How can windows applications connect to oracle servers?
How to convert raw data type into text in oracle? Explain
