Re: Loading Data from Text file to Oracle Database
Date: 17 Jan 2003 07:24:32 -0800
Message-ID: <eafae386.0301170724.37b3ba4a_at_posting.google.com>
Well SQL LOADER is your simplest option, since developer can also invoke SQLLDR.
vinothkumar <member22879_at_dbforums.com> wrote in message news:<2402055.1042795932_at_dbforums.com>...
> Hi,
> I need to import data from a text file to Oracle 9 database. This is an
> web application in which user may load the file from any location and
> trigger a process to upload the data from the text file. (File location
> and other details about the file are considered).
>
> I would like to know whether it is possible to upload the file at
> the runtime.
> Something similar to bulkinsert in SQL Server.
> (We have also tried SQL Loader of Oracle, SQL Loader in Oracle is a
> Administrator utility)
>
>
> Please help me if you know any solution for this problem.
>
> Thanks and Regards
> -Vinoth Kumar
Received on Fri Jan 17 2003 - 16:24:32 CET