Re: exec_immediate

  • From: Oded Maimon <oded.maimon@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 07 Jul 2005 16:23:27 +0200

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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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





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






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

Other related posts: