Re: dbms_sql question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 29 Jan 2001 20:47:07 -0000
Message-ID: <980802024.4244.1.nnrp-14.9e984b29@news.demon.co.uk>

There's an example of one way to
do this on my web-site under

Miscellaneous -> dynamic pl/sql;

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Jeremy Ovenden wrote in message ...


>Suppose we have a piece of SQL which is unknown, e.g. it might be

>

>select ename,dept

>from   emp;

>

>or it could be

>

>select col1,col2,col3

>from   tab1 a,

>       tab2 b

>where  a.

>.... etc

>

>What I would like to do is execute this piece of SQL using dbms_sql but

>would like to be able to get the data returned by the select into pl/sql

>variables.

>

>My question is: (how) can I identify the columns that are being selected?

>

>BTW looking for a solution on 8.0.5+

>

>--

>

>Jeremy

>

>

Received on Mon Jan 29 2001 - 14:47:07 CST