Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dynamically execute sql statements in oracle

Re: Dynamically execute sql statements in oracle

From: Christoph Ritterbach <christoph.ritterbach_at_t-online.de>
Date: Sat, 30 Apr 2005 18:49:25 +0200
Message-ID: <pan.2005.04.30.16.49.25.191422@t-online.de> 





Am Fri, 29 Apr 2005 07:39:03 -0700 schrieb bucycle:



> RUN ('UPDATE '||ctest1.table_name||' SET revisionname =

> '''||ctest1.schemaname||''' ||SUBSTR(revisionname,1,16)');

> 




Try 


EXECUTE IMMEDIATE 'UPDATE ....';

Received on Sat Apr 30 2005 - 11:49:25 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US