Home -> Usenet -> comp.databases.oracle -> String to be used as column name.

String to be used as column name.

From: Vaskin Kissoyan <root_at_quest.net>
Date: 1996/04/20
Message-ID: <31793AF4.41C6_at_quest.net>#1/1 






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;





---
Vaskin Kissoyan
Quest Interactive Media
http://www.quest.net


Received on Sat Apr 20 1996 - 00:00:00 CEST












Original text of this message