Re: exec_immediate

DMBS_SQL - the old fasion - not very pretty way (http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_sql.htm)

For ddl - dbms_utility -
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_util2.htm#1002233

for dynamic select statment:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96624/11_dynam.htm#10961

Maverick Gaulet wrote:

>Thank you in advance.
>But after I visit the link. I found that command can't be run in form 6i front-end. Do you have solution to substitute that command by using another command that synchrone with exec immediate but it can runs in form6i front-end.
>
>
>Regards,
>
>Mave
>
>----- Original Message -----
>From: "Oded Maimon" <oded.maimon_at_gmail.com>
>To: oracle-l_at_freelists.org
>Subject: Re: exec_immediate
>Date: Thu, 07 Jul 2005 12:34:04 +0200
>
>
>
>>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
>>
>>
>
>
>
>

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