Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SqlLoader -ks-

Re: SqlLoader -ks-

From: Karen <Morgan-Karen_at_home.com>
Date: Tue, 11 Sep 2001 00:09:00 GMT
Message-ID: <wCcn7.738916$K5.79275824@news1.rdc1.nj.home.com>


Use Oracles built-in package called utl_file which allows you to read an write to/from text files.

Another option is to use Visual C++ and an odbc connection to accomplish this task.

Karen
Sr. Applications Analyst/Team Leader/DBA

"kshathrya" <kshathrya_at_hotmail.com> wrote in message news:tppoagnu30o7f_at_corp.supernews.com...
> Hi,
> Is there a way we can load data into oracle using some wizards or
> something, from excel or flat files, without having to create conrol
files.
> In the sense, my flatfiles first column will be the column name of that
> particular table, whichj has to be generated in runtime. We have utilities
> in sqlserver, but am wondering whether there is any way or tool that can
> help.
>
> thanks
> ks
>
>
Received on Mon Sep 10 2001 - 19:09:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US