Re: Variables as Column names in PL/SQL

From: Dave Mausner <dmausner_at_brauntech.com>
Date: 1996/07/19
Message-ID: <4sp19i$cbo_001_at_news.psi.net>#1/1


In article <01bb7441.aa7c7500$d482aec7_at_geoff>,

   "Geoff Dewhurst" <100354.1260_at_compuserve.com> wrote:
> Does any one know we can pass a variable into a function and use this as
>a column name in an UPDATE statement.

sure, have a look at the DBMS_SQL packaged procedures which you will find in the ...rdbms/admin directory. basically, you build the sql string as text, which means you can concatenate that variable as a column name.

you're welcome.

Dave Mausner, Managing Consultant, Braun Technology Group, Chicago. Received on Fri Jul 19 1996 - 00:00:00 CEST

Original text of this message