Interested to Buy Any Domain ? << Click Here >> for more details...
How you open and close a cursor variable.Why it is required?
- 2 Answers
- 3792 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / venkat
open cursor then the cursor points to the starting of the data......close the cursor it clears the data after the execution of a program
| Is This Answer Correct ? | 0 Yes | 0 No |
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
what are the differen between key flexifild and discriptive fiexifild.
What are the restrictions in a oracle read only transaction?
What is meant by redo log buffer ?
How to login to the server without an instance?
How many types of tables are there in oracle?
How can I see all tables in oracle?
What is partitioned table in Oracle?
What is a partition in oracle?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
What do database buffers contain?
What are the different types of synonyms?
Oracle General 
