Re: PL/SQL for file extraction?
From: Blv n Drms <blvndrms_at_aol.com>
Date: 1995/04/29
Message-ID: <3nur7k$dhk_at_newsbf02.news.aol.com>#1/1
END;
/
Date: 1995/04/29
Message-ID: <3nur7k$dhk_at_newsbf02.news.aol.com>#1/1
You can use pl/sql for this. It is not the most productive method but if you have to do some testing and data manipulation prior to outputing the data to a file it would probably be ok. Here's how:
CREATE OR REPLACE PROCEDURE test1 AS
tmp_col number;
BEGIN
select test_column
into tmp_col
from test_table;
tmp_col := (tmp_col - 9987)/35;
DBMS_OUTPUT.PUTLINE('This is the value of test amount is
$'||tmp_col);
END;
/
set serveroutput on size 100000
spool flat.file
EXECUTE test1;
spool off
Jack Richter Received on Sat Apr 29 1995 - 00:00:00 CEST