When is the results table for the query in a DECLARE CURSOR statement created ?
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
What is the difference between view and materialized view? 20.09.08
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized view -...How to Select last N records from a Table? 14.05.08
select * from (select rownum a, CLASS_CODE,CLASS_DESC from clm) where a > ( select (max(rownum)-10) from clm) Here N = 10 The following query has a Prob...Difference between an implicit & an explicit cursor? 11.05.08
PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than o...How you open and close a cursor variable.Why it is required? 11.05.08
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...What is read-only cursor ? 10.04.08
A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword • a UNION o...What is a result table ? 10.04.08
A result table is the product of a query against one or more tables or views ( i.e. it is the place that holds the results of a query)....Is DECLARE TABLE in DCLGEN necessary? Why it used? 12.03.08
It not necessary to have DECLARE TABLE statement in DCLGEN. This is used by the pre-compiler to validate the table-name, view-name, column name etc., during p...How do you leave the cursor open after issuing a COMMIT ? 12.03.08
Use WITH HOLD option in DECLARE CURSOR statement. But, it has not effect in psuedo-conversational CICS programs....What is get cursor field? 18.03.07
GET CURSOR statement transfers the name of the screen element on which the cursor is positioned during a user action into the variable . GET CURSOR FIELD [O...What is the difference between view and materialized view? 04.08.06
View - store the SQL statement in the database and let you use it as a table. Everytime you access the view, the SQL statement executes. Materialized View...