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 15:00:26 +0300
Message-ID: <93mrku$pfl$1@alpha.main.vsu.ru> 






Hi, Sybrand!



> 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...
Received on Fri Jan 12 2001 - 06:00:26 CST












Original text of this message













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