Re: Convert CSV data held in a CLOB into columns

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 08 Dec 2007 15:39:41 -0800
Message-ID: <1197157179.144099@bubbleator.drizzle.com>

jeremy wrote:
> In article <1197136923.818884_at_bubbleator.drizzle.com>, DA Morgan says...

>>> Can a CLOB be referred to as an external table? If so then we can keep 
>>> the entire process IN the database and cut out steps like establishing 
>>> directory objects, placing CSV file in corresponding o/s directory etc. 
>> In theory an external table should be able to handle anything that
>> SQL*Loader can handle. They are essentially the same technology.

>
> - is there a way to tell Oracle
> "look at the content of this CLOB and treat it like it is an external
> table containing CSV content".

This makes no sense.

Tell a database engine to look at a variable and pretend that variable is a table on the file system?

Want a second shot at this?

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Dec 08 2007 - 17:39:41 CST