SEO

#1 (**permalink**) 02-24-2008, 05:32 AM

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?

#2 (**permalink**) 02-24-2008, 05:32 AM

On Wed, 30 Jun 2004 23:36:04 GMT, "MARA80" <maragiunta@email.it>
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?
>

Read the chapters on sqlloader in the Oracle Server Utilities manual.

--
Sybrand Bakker, Senior Oracle DBA

#3 (**permalink**) 02-24-2008, 05:34 AM

On Wed, 30 Jun 2004 23:36:04 +0000, MARA80 wrote:

>
> Hi, I'm discovering Oracle 8i Database just now and I'm trying to praticize
> the best I can.

You will boldly go where everybody else has been before.

> But I'm at beginnings and everything seems to me very hard.

Relax. You'll start enjoying it atsome point.

> 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?

SQL*Loader, perl, vi, sed or a combination.

--
Well-behaved women seldom make history

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

IMPORT DATA FROM TXT FILE