ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From miro <miroconn...@yahoo.com>
Subject Re: sql ant task
Date Fri, 24 Aug 2007 13:07:36 GMT

Thank you very much for your reply can you send me a simple example of  using
exec task to execute a sql file ?
Thanks
Miro


Krzysztof KucybaƂa wrote:
> 
> I suppose the easies, though maybe not the smartest way to do it, would 
> be to use exec task. Of course that is only useful if you have a command 
> line interface for the db that You're trying to use. You could put this 
> in some *.sql file and have it exec-uted from ant. Does that help?
> 
> Best regards,
> Krzysztof
> 
> temp temp wrote:
>> 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.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
> For additional commands, e-mail: user-help@ant.apache.org
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/sql-ant-task-tf4323270.html#a12312062
Sent from the Ant - Users mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@ant.apache.org
For additional commands, e-mail: user-help@ant.apache.org


Mime
View raw message