Re: Dynamice SQL in Oracle

Madhivanan wrote:
> 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

Are you comparing products here *or* trying to learn Oracle? Do yourself a favor, move your fingers/mouse/eye balls/brain and do some reading about Oracle. After that if you don't understand something... post it here.

Others have provided all sorts of links to docs.

Regards
/Rauf Received on Tue May 10 2005 - 03:46:05 CDT