Re: Select Statement help

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: Sun, 26 Jul 1998 17:39:33 GMT
Message-ID: <6pfpl1$ank@bgtnsc03.worldnet.att.net>

On 23 Jul 98 08:38:57 -0500, ken.stevens_at_srs.gov (Ken Stevens) wrote:

>I want to beable to dynamically change the column name
>in the variable and then select the column name from the variable in the
>select statement. Is this possible?

It sounds like you want to create SQL statements on the fly. This is referred to as "Dynamic SQL". You can do this with Oracle's DBMS_SQL package. It's documented in the Application Developers Guide.

Jonathan Received on Sun Jul 26 1998 - 12:39:33 CDT