Oracle-L: RE: RE: External Tables question

From: Khedr, Waleed <Waleed.Khedr_at_FMR.COM>
Date: Wed, 05 Nov 2003 11:19:33 -0800
Message-ID: <F001.005D5AEF.20031105111933@fatcity.com>

select *
from
(Select rownum m_id, table_name
from dba_tables)

-----Original Message-----
Sent: Wednesday, November 05, 2003 12:10 PM To: Multiple recipients of list ORACLE-L

cant you use rownum with a 'merge'?
>
> From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM>
> Date: 2003/11/05 Wed AM 11:34:33 EST
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> 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 seem to find one thing that
> I'd like (I have already RTFM'd but may have missed some part).
>
> Is there a way I could load the line number of the text file as a column
in
> the table? line number isn't hard coded but can record number be used
> (somehow)?
>
> Any ideas? TIA
> Raj
>

> ----
> Rajendra dot Jamadagni at nospamespn dot com
> All Views expressed in this email are strictly personal.
> QOTD: Any clod can have facts, having an opinion is an art !
>
>
>

> **********
> This e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
attorney
> work product or exempt from disclosure under applicable law. If you have
> received this message in error, or are not the named recipient(s), please
> immediately notify corporate MIS at (860) 766-2000 and delete this e-mail
> message from your computer, Thank you.
>

> **********4
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Nov 05 2003 - 13:19:33 CST