Title: External Tables question
What about
rownum?
Waleed
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]Sent: Wednesday, November 05,
2003 11:25 AMTo: Multiple recipients of list
ORACLE-LSubject: External Tables question
I am trying to use external
You can't load line number into the table except in the case where line number is
actually contained in the table as a column. External tables are great for loading
things into the proper realtional tables but cannot be used for much otherwise.
You cannot index an external table. The best thing
cant you use rownum with a 'merge'?
From: Khedr, Waleed [EMAIL PROTECTED]
Date: 2003/11/05 Wed AM 11:34:33 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: External Tables question
What about rownum?
Waleed
-Original Message-
Sent: Wednesday
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: External Tables question
What about rownum?
Waleed
-Original Message-
Sent: Wednesday, November 05, 2003 11:25 AM
To: Multiple recipients of list ORACLE-L
I am trying to use external tables, but can't
Title: RE: External Tables question
Raj, here is an example of control file:
load data
into table TABLE_NAME truncate
(piece recnum
...
)
Alex.
-Original Message-
From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 05, 2003 8:25 AM
To: Multiple
Title: RE: External Tables question
Thanks everyone ... appreciate your input.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have
