Re: exec_immediate

i believe this is "execute immediate" without the underscore (or "exec immediate" for shortcut),

you just run something like that " exec immediate 'update tab set col=2' "

there is more options to use with bind variables and selecting into parameters and so, but this is in the documentation.

or (the first thing in google search for "oracle execute immediate") http://www.dbasupport.com/oracle/ora9i/execute_immediate.shtml

if i remember correctly you can use it forms.

Maverick Gaulet wrote:

>Hi all,
>
>Pls anyone on this list, pls give me a simple explanation about what is 'exec_immediate' and how to use it. Can I use that syntax in oracle developer-form 6i?
>
>
>TIA
>
>sony
>
>
>

--
http://www.freelists.org/webpage/oracle-l