I trying to execute small script using ant  , here is the script
  SET NEWPAGE 0
  SET SPACE 0
  SET LINESIZE 80
  SET PAGESIZE 0
  SET ECHO OFF
  SET FEEDBACK OFF
  SET HEADING OFF
  SET MARKUP HTML OFF
  SET ESCAPE \
  SPOOL DELETEME.SQL
  select 'drop table ', table_name, 'cascade constraints \;' from user_tables
  
  how to run this script  using ant sql task
  Thanks
  Miro

       
---------------------------------
Fussy? Opinionated? Impossible to please? Perfect.  Join Yahoo!'s user panel 
and lay it on us.

Reply via email to