Re: dynamic sql

Check out the chapter on Native Dynamic SQL in the PL/SQL User's Guide and
Reference for an explanation of the 'execute immediate' PL/SQL syntax. In
many cases this is much easier to code the DBMS_SQL, but DBMS_SQL has the
advantage of providing a programmatic way to determine the column
definitions of dynamic SELECT statements.

----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048


"blue" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> i 'm looking for the documentation about dynamic sql ?
> it 's more effiicent than dbms_sql.
>
> if you have a documentation or some address of the site, i 'm interessed .
>
> thanks
>
>