When is the skeleton cursor table created ?
During the execution of the BIND PLAN command.
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
in which scenerio we use interfaces,abstract and concrete class?Which one is better and appropriate?Differentiate these three terms in depth. 27.10.08
Interface - used to define a skeleton. Classes who want to confirm to that skeleton implementsts the interface Abstract class - Use abstract class when y...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...Where is the access path logic created by the DB2 Optimizer stored ? 12.04.08
The access path logic is stored as skeleton cursor tables in the SCT02 Directory table....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...When is the results table for the query in a DECLARE CURSOR statement created ? 10.04.08
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....What is the significance of the CURSOR WITH HOLD clause in a cursor declaration ? 03.04.08
The clause avoids closing the cursor and repositioning it to the last row processed when the cursor is reopened....What is a LIKE table and how is it created ? 01.04.08
A LIKE table is created by using the LIKE parameter in a CREATE table statement. LIKE tables are typically created for a test environment from the production...What is Skeleton cursor table (SKCT) ? 24.03.08
The Executable form of a Plan. This is stored in sysibm.sct02 table....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...How do I change the type of cursor and hide a cursor? 12.03.06
We can change the cursor type by using function _setcursortype( ). This function can change the cursor type to solid cursor and can even hide a cursor. Followin...