I would like to know how do i create a flat file from a query in oracle. For example i would like to create a select statement and the output to the flat file should be like this:
name,location,address
......
Later on, this task will be embedded in a unix script (the call for the procedure if created in a procedure) and i would like to know how would i achieve that. The flat file will be stored in a unix directory. I used spooling but it is printing even the sql statements i have executed in sqlplus so i don't want to use that. I have searched on utl_file package, but this requires to be installed in the oracle and with that, i need to communicate to a DBA to add the package and it takes time or it will be laborious when it comes to requesting. What are other ways?
Any help would be of much service.