Re: executing a select from a string
From: (wrong string) ³ <pp_at_inwar.com.pl>
Date: 1997/05/26
Message-ID: <01bc69b5$b00d7400$7179b5c2_at_PP.system.inwar.com.pl>#1/1
Date: 1997/05/26
Message-ID: <01bc69b5$b00d7400$7179b5c2_at_PP.system.inwar.com.pl>#1/1
Hi
Your must read script dbmssql.sql ( <Oracle_Home>\rdbms7x\Admin). There is a examples use dynamic SQL.
Pawel Plichta
Invar System Poland
CG <christian.gregory_at_citicorp.com> napisa³(a) w artykule
<3384E70C.1628_at_citicorp.com>...
> Hi all, I'm back...
>
> I have a very simple question, the answer in which I cannot find in
> the books...
>
> I'm declaring a string : str1 varchar2(100) :=
> 'select col into xyz from thistable';
>
> now in the begin section, I want to execute this string: str1.
> How do I do this ?
>
> Regards Chris
>
Received on Mon May 26 1997 - 00:00:00 CEST