Hi,
I've found the answer. Thanks.
-Original Message-
From: CHAN Chor Ling Catherine (CSC)
Sent: Tuesday, May 22, 2001 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject:OT : Unix
Hi David,
If there is a remote possibility of loading this data back into Oracle XX
database (or any other, for that matter), then what you are doing makes
perfect sense. I used to unload data into flat files when I worked on the
mainframe systems a few years ago. And a few times we did have to
How about:
DECLARE
TYPE NumList IS TABLE OF emp.empno%TYPE;
enums NumList;
BEGIN
DELETE FROM emp WHERE deptno = 20
RETURNING empno BULK COLLECT INTO enums;
-- if there were five employees in department 20,
-- then enums contains five employee numbers
END;
Jared
On
My first recommendation would be to do this with Perl and DBI.
Fairly simple that way.
If not, try using SQL generating SQL to spool the data out.
Check out dump.sql at www.cybcon.com/~jkstill/util, and modify
for your needs.
UTL_FILE will probably not work for this due to buffer
What did you use as a delimiter, and are their any limits on tables I can
write to a file?
Thanks, Dave
On Mon, May 21, 2001 at 09:47:20PM -0500, Deshpande, Kirti wrote:
Hi David,
If there is a remote possibility of loading this data back into Oracle XX
database (or any other, for that
Thanks, Dave
On Mon, May 21, 2001 at 08:05:23PM -0700, Jared Still wrote:
My first recommendation would be to do this with Perl and DBI.
Fairly simple that way.
If not, try using SQL generating SQL to spool the data out.
Check out dump.sql at www.cybcon.com/~jkstill/util, and modify
Hello Gurus
I just would like to know when this statement SET TRANSACTON USE ROLLBACK
SEGMENT 'XXX' should be used exactly.
In the sense should I always write it after a BEGIN(for all my programs) or
should I write it in processes which involves HUGE volume of records.
Please clarify
OK, this is *way* off topic for this list.
At times the folks here stray from Oracle, but if
you wish to start political discussions, do it somewhere
else please.
Jared ( the list owner )
On Monday 21 May 2001 13:40, palestine Qods wrote:
Hello,
Please take a look at this and give your
After looking at the address, I realized that this subscriber is
simply a spam account, and removed it accordingly.
Jared
On Monday 21 May 2001 13:40, palestine Qods wrote:
Hello,
Please take a look at this and give your reaction :
http://www.humanityonhold.com/intifada.html
YOUR
David,
It was mainframe and COBOL shop, we did not use delimiters in the data
files. All the files were using fixed format for data fields. There was one
file per table (datasets as they are called in the Burroughs (Unisys) DMSII
database). I think one file per table would be much easier to deal
101 - 110 of 110 matches
Mail list logo