Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: IMPORT DATA FROM TXT FILE
I can't understand your sarcasm (Daniel and Hans). I'm not going to explain
why I developed my "application" as you called it since it's none of your
business. And further more, since I've not asked any kind of fee for that
"application", no one is entitled to make any sarcasm comment. What's wrong
with you fellows ?
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1088687826.876150_at_yasure...
| Mytskidis Georgios wrote:
| > ??
| >
| > 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 !!)
|
| And exactly what does your "application" do that isn't done without
| any application using external tables?
|
| --
| Daniel Morgan
| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
| damorgan_at_x.washington.edu
| (replace 'x' with a 'u' to reply)
|
Received on Fri Jul 02 2004 - 01:52:49 CDT