Home » SQL & PL/SQL » SQL & PL/SQL » How to do display a 'SELECT *' in a PL/SQL ?
How to do display a 'SELECT *' in a PL/SQL ? [message #8614] Thu, 04 September 2003 02:48 Go to next message
Gerald
Messages: 54
Registered: January 2001
Member
Dears,

here a more clearer question than last time:
here is the script 'without the DECLARE & Begin'
(...)
str :='select * from VALNULL';
cur:=dbms_sql.open_cursor;
dbms_sql.parse(cur,str,dbms_sql.native);
Status:=dbms_sql.execute(cur);
dbms_output.put_line(cur); <<<--- ??
dbms_sql.close_cursor (cur);
(...)

nothing comes OUT !
So what is the way to display the fields, if you don't
know (and want to know) their name ?
is it possible ?

Take care
Gerald
Re: How to do display a 'SELECT *' in a PL/SQL ? [message #8619 is a reply to message #8614] Thu, 04 September 2003 11:33 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Previous Topic: get the num of rows in a table with out using count?
Next Topic: sqlplus error
Goto Forum:
  


Current Time: Fri Apr 26 04:07:05 CDT 2024