Re: exec_immediate

  • From: Oded Maimon <oded.maimon@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2005