Re: IMPORT DATA FROM TXT FILE

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Thu, 01 Jul 2004 06:01:09 GMT
Message-ID: <FMNEc.58889$E84.43621@edtnps89>

MARA80 wrote:

> Hi, I'm discovering Oracle 8i Database just now and I'm trying to
> praticize the best I can.
> But I'm at beginnings and everything seems to me very hard.
> I have to import in a Oracle DB a txt file (formatted) and I have to
> create a table with it.
> Which is the right code to solve this problem?

The right code starts with 'CREATE TABLE' and includes 'ORGANIZATION EXTERNAL' ... In other words - assuming the correct version of the database - the correct code is NO code at all, but a simple mapping over the file.

This, and many other useful tidbits are in the documentation.

/Hans Received on Thu Jul 01 2004 - 01:01:09 CDT