Hello,
I have been tasked with writing a script that will prompt the user for a
ticket number,some other info, and a sql query. The script should create a
directory based on ticket number (easy enough) create files in the directory
that contains info based on second query, and then and here is where I am
stuck...
The script must connect to the sqldatabase (ie sqlplus [EMAIL PROTECTED]
), turn on spooling, then run the query that was entered by user in step 1,
disconnect from the database and continue. Any clues on how this can be
accomplished?
One last question while I am here, I am looking to split the output of the
above query into separate files containing 10000 entry lines. This can be
done using the unix split command "split -l 10000 fallout.txt" Looking
through the info I have using the perl split there is no format like this.
I assume though,. that this can be done...what would the format be?
Thanks for any help in advance.
