Re: PL/SQL question

From: Avi Abrami <aabrami_at_intersystemsww.com>
Date: Wed, 13 Dec 2000 08:12:24 +0200
Message-ID: <3A371348.1E8A6FEF@intersystemsww.com>

andyho99_at_yahoo.com wrote:

> Hi,
>
> Is it possible to declare a cursor where treat a table name as a
> variable in PL/SQL (tried to retrieve data from same column name among
> many tables)? I had been using variables in where clause but not table
> name. It seemed that PL/SQL didn't like my idea.
>
> Thanks, Andy
>
> Sent via Deja.com
> http://www.deja.com/

Hi Andy,
If you're asking what I think you're asking, then you can do this using native dynamic PL/SQL which is available in Oracle 8i.

Alternatively, you can use the PL/SQL package - DBMS_SQL which is available from Oracle 7 and above.

These features are explained in the Oracle documentation which is available from Technet

http://technet.oracle.com

Look at the "PL/SQL Users Guide"

HTH,
Avi. Received on Wed Dec 13 2000 - 00:12:24 CST