Where to save a SQL*PlUS report (oracle 9i)??

m making a project (website on ONLINE SHOPPING) in java using oracle 9i as back end.


my guide has asked me to include at least 10 reports for the project.


i found that there was a special feature in oracle 9i to generate reports...now i know the complete format of preparing this SQL*PLUS report..it can be made in any editor..i hav chosen NOTEPAD as my editor..


I dont know where to save this File so that SQL can execute it...pls tell me where should i save it...???


the c:\ drive of my PC holds oracle..





its kinda urgent...ss plz reply soon..


thanx in advance..

Where to save a SQL*PlUS report (oracle 9i)??
I don't know where oracle 9i will save the reports. But if you try to retreive a report by clicking on "open", it would take you to a default directory, where oracle expect to find reports that are saved under "sql" extension. Hope this will answer your question. Good luck
Reply:You need training little grasshopper. If you are using just SQL*Plus to generate reports, you can execute the script by full path and spool the file to a full path.





i.e.





spool c:\myoutput\shoppingcart\report1.txt


SQL%26gt;@c:\myproject\get_sale_orders.sql


spool off





You can put the execution in a CRON or Windows job that can run periodically. I'm pretty sure you're on Windows and not Linux or UNIX. So, you can create a batch job to run in the Windows Task Scheduler.
Reply:how would i know.