Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 10 G (Is it possible to use the command line inside a sp?)
Oracle 10 G [message #342062] Thu, 21 August 2008 04:03 Go to next message
rangan.s
Messages: 75
Registered: February 2008
Location: chennai
Member
Hi,

I have a requirement like i need to write the selected column from table and i want to write in a file and need to zip is it possible? command line will work inside sp??


Thanks,
Rangan S
Re: Oracle 10 G [message #342065 is a reply to message #342062] Thu, 21 August 2008 04:42 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
utl_file to write in a file.
Search for zip on asktom.oracle.com

Regards
Michel
Previous Topic: Can i do this in a Single query
Next Topic: Invalid Cursor
Goto Forum:
  


Current Time: Sat Dec 10 07:12:09 CST 2016

Total time taken to generate the page: 0.10844 seconds