Unload data to ascii files using pl/sql

From: pankaj <pankaj.patel_at_ladbrokes.com>
Date: Thu, 31 Jan 2002 17:03:27 -0000
Message-ID: <3c597905_4@corp-goliath.newsgroups.com>

Hi All ,

Solaris 8 on 220R
Oracle 8i

I am quite new Oracle and PL/SQL and need some help. I have been asked to unload some data ...well quite a lot of data from the Oracle instance I have.
My question is does PL/SQL or Oracle have an unload statement i.e

unload to /tmp/xx.unload
select * from tab1 , tab2
where tab1.id = tab2.id
and tab1.customer_stake > 100

If not can someone point me in the right direction as how I can achieve this without using any third party tools.

Cheers

Pankaj

---

Posted Via Binaries.net = SPEED+RETENTION+COMPLETION = http://www.binaries.net Received on Thu Jan 31 2002 - 11:03:27 CST