Re: insert/update tool or command line

From: <prochak_at_my-dejanews.com>
Date: Fri, 04 Sep 1998 14:03:29 GMT
Message-ID: <6sorvh$nf4$1@nnrp1.dejanews.com>

In article <01bdd8a2$b414b740$0a6464c8_at_ctx>, "Mosle" <mosle_at_hotmail.com> wrote:
> I need to insert rows of data into thousands of records on a yearly basis.
> I will like some advice/recommendation for a tool or SQL command to
> automate this procedure.
> Any ideas?
>
> Thanks
> --
> Mosle
> mosle_at_caribsurf.com
>

By saying "thousands of records on a yearly basis" do you mean:

once a year, you want to load lots of records all at once? or
over the course of a year, you load about 3-5records per day?

For (A) then sql*loader is the tool you want.

For (B) then a simple front-end application program would be appropriate.

How you receive data can make a difference also. If the data is one or more files with many records, then again sql*loader is the tool to use. If the data comes from a manual process (eg, requests coming in by phone from customers), then an application that the operator can easily use is a good choice.

The application program might be a simple PERL script, Visual BASIC program, an ORACLE FORM, or other language. Let us know some more information, and we can give more appropriate suggestions.

I hope these options help.

--
Ed Prochak
Magic Interface, Ltd.
440-498-3702

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 04 1998 - 09:03:29 CDT