Hello people, at the moment, I have a database server running HP-UX and Oracle. From time to time, I need to extract data from oracle, and then do some data management (Awk, sed) within unix. At the moment, what I do is to copy the output from my oracle query and then paste into a file on another login/ telnet session. This is definitely not ideal.
Is it possible to have a unix script that would perhaps log into oracle and then redirect the output of an oracle query into a normile unix file?
Please assist
The Khoom