how to query oracle database and send output to screen
Date: 2000/07/29
Message-ID: <8ltul0$rka$1_at_nnrp1.deja.com>#1/1
Hi,
#!/usr/local/bin/perl
database mydatabase\_at_n_shm;
I need to query my oracle database 8.1.6 on solaris 7 and send the
results to the screen. I might also need to send the output to a
file. I've looked into DBD and DBI but there are some modifications
that need to be done to some java oracle binaries to get it to work.
I'd rather not modify these files on my production server. I've done
this with informix:
$ENV{INFORMIXSERVER} = "n_shm";
open DBACCESS, "| /u/informix/bin/dbaccess";
print DBACCESS qq{
UNLOAD TO '/u/myfile'
FROM a_table;
};
close DBACCESS;
Can someone show me how to do this in oracle? Thanks in advance...
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Jul 29 2000 - 00:00:00 CEST