Re: IMPORT DATA FROM TXT FILE

From: Mytskidis Georgios <medicon_at_ath.forthnet.gr>
Date: Thu, 1 Jul 2004 11:34:45 +0300
Message-ID: <cc0ia8$ee2$1@usenet.otenet.gr>

??

I've developed a small application named Text2Oracle which makes what you're asking for :

1).It takes as source a text file
2).You define the delimeter which distinguishes the text values
3). You connect to Oracle and select the destination-target table (provided

that you've already created it).
4). You select which columns of the pre-selected oracle table will be used and for those columns you assign for every one the input data. These data may be a spesific "colon of the source text file", a value from an oracle sequence or a standard fixed value (which you provide) 5). The final step is for the application to translate the data and your settings to Oracle INSERT commands and execute the provided script. If any error occurs then the application points to the error and automatically rollsback.

If you're interested send me an e-mail (no charge of course !!)

-- 
Best Regards

G.MYTSKIDIS
MYTSKIDIS_G_at_GI-NET.GR


"Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
news:FMNEc.58889$E84.43621_at_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 - 03:34:45 CDT