Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
Oracle 3
« Previous
Next »
Which statement is used to associate a cursor variable with the dynamic SQL statement?
Options
- OPEN
- USING
- OPEN FOR
- WITH
CORRECT ANSWER : OPEN FOR
Discussion Board
OPEN FOR
The OPEN FOR statement is used to associate a cursor variable with the dynamic SQL statement. The OPEN-FOR statement executes the SELECT statement associated with a cursor variable. It allocates database resources to process the statement, identifies the result set (the rows that meet the conditions), and positions the cursor variable before the first row in the result set. Use an OPEN FOR statement to associate a cursor variable with the dynamic SQL statement. In the USING clause of the OPEN FOR statement, specify a bind variable for each placeholder in the dynamic SQL statement. The USING clause cannot contain the literal NULL. To work around this restriction, use an uninitialized variable where you want to use NULL.
Prajakta Pandit 02-24-2017 06:57 AM
cursor varable in dynamic sql
pretty sure its using or question is badly written.
john 01-29-2015 02:24 PM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲