Solved

which of the following is used to obtain column data values for the row(s) selected?

Posted on 2001-07-18
4
3,724 Views
Last Modified: 2008-02-20
After successfully executing FETCH_ROWS() on a SELECT cursor via DBMS_SQL, which of the following is used to obtain column data values for the row(s) selected?  
Choice 1  
 DBMS_SQL.VARIABLE_VALUE()  
Choice 2  
 DBMS_SQL.BIND_VARIABLE()  
Choice 3  
 DBMS_SQL.DEFINE_COLUMN()  
Choice 4  
 DBMS_SQL.GET_COLUMN()  
Choice 5  
 DBMS_SQL.COLUMN_VALUE()  
0
Comment
Question by:micky_1_7
  • 2
4 Comments
 
LVL 9

Expert Comment

by:dbalaski
ID: 6296701
Yeaaaa --  we are all going to get    Brainbench   Certified!!!
0
 
LVL 7

Expert Comment

by:q2eddie
ID: 6296771
Hi, micky.

Choice 6
DBMS_SQL.SIT_UBU_SIT('good_dog;')

Bye. -e2
0
 
LVL 7

Accepted Solution

by:
q2eddie earned 5 total points
ID: 6296774
Oops, my bad.

Choice 6
DBMS_SQL.FETCH_FRISBEE('ubu;')

Bye. -e2
0
 
LVL 3

Expert Comment

by:modder
ID: 6297229
LOL

ROTFLMAO

Woof.

modder
Community Support Moderator@Experts-Exchange


q2eddie,

I'm going to recommend you for a medal.

micky_1_7,

Got the message yet?

Go somewhere else to cheat your way through an exam.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question