Re: String to be used as column name.
From: Vaskin Kissoyan <root_at_quest.net>
Date: 1996/04/20
Message-ID: <31794586.167E_at_quest.net>#1/1
Date: 1996/04/20
Message-ID: <31794586.167E_at_quest.net>#1/1
Vaskin Kissoyan wrote:
> PL/SQL programmers, please help.
>
> How can I use a varchar2 parameter as a column name in a select
> statement???
>
> Eg.
>
> create or replace procedure test(THISONE in varchar2)
> IS
> cursor result_cursor is
> select * from emp where THISONE = 'blah';
> BEGIN
> ...
> END;
Answering my own question:
Use the PARSE procedure!
--- Vaskin Kissoyan Quest Interactive Media http://www.quest.netReceived on Sat Apr 20 1996 - 00:00:00 CEST