Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL: variable column & table name in select

Re: PL/SQL: variable column & table name in select

From: Viatcheslav V. Kopeikin <kvv_at_main.vsu.ru>
Date: Fri, 12 Jan 2001 17:31:20 +0300
Message-ID: <93n4fo$5c3$1@alpha.main.vsu.ru>

Hi, Sibrand!

>> In Oracle 7 and Oracle 8.0, you need to use dbms_sql to accomplish
>> this. In Oracle 8i you can use Native Dynamic SQL. If you want a more
>> specific answer, please post which version you are using.
 

> Thank you and all the participants of discussing. dbms_sql really solves
 the
> problem.
> And what do you mean saying "Native Dynamic SQL"? I use 8i and haven't yet
> studied a number of features...

    Sorry for stupid question ;), I've found the corresponding place in documentation.

---
WBR, Viatcheslav.
Received on Fri Jan 12 2001 - 08:31:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US