Dynamice SQL in Oracle

From: Madhivanan <madhivanan2001_at_gmail.com>
Date: 9 May 2005 23:59:04 -0700
Message-ID: <1115708344.473404.68170@o13g2000cwo.googlegroups.com>

Is it possible to use Dynamic SQL in Oracle as in SQL Server2000?

I used this

declare t table(i integer, n varchar(10));

insert into t values(2,'dfg');
insert into t values(2,'dfg');
insert into t values(2,'dfg');
insert into t values(2,'dfg');
insert into t values(2,'dfg');

select * from t

but I get the error

insert into t values(2,'dfg');
*
ERROR at line 2:

ORA-06550: line 2, column 1:
PLS-00103: Encountered the symbol "INSERT" when expecting one of the
following:

begin function package pragma procedure subtype type use
<an identifier> <a double-quoted delimited-identifier> form
current cursor
The symbol "begin" was substituted for "INSERT" to continue. ORA-06550: line 12, column 0:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the
following:
. , @ ; for <an identifier>
<a double-quoted delimited-identifier> group having intersect
minus order partition start subpartition union where

Madhivanan Received on Tue May 10 2005 - 01:59:04 CDT