Home » SQL & PL/SQL » SQL & PL/SQL » how do i do incremental load using procedure
how do i do incremental load using procedure [message #222225] Fri, 02 March 2007 06:31 Go to next message
lokesh.sql
Messages: 9
Registered: November 2006
Location: Pune
Junior Member
Hi All,

Can any one suggest how I can do the incremental load of the .CSV file into the database? Using procedure, so that I schedule the procedure daily. Please help me out.

Thanks in advance
Regards
Lokesh
Re: how do i do incremental load using procedure [message #222226 is a reply to message #222225] Fri, 02 March 2007 06:33 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
what do you mean by incremental load?
Re: how do i do incremental load using procedure [message #222315 is a reply to message #222226] Fri, 02 March 2007 15:41 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Using external table, for example? This concept would allow you to load data using (PL/)SQL and, thus, schedule the job.
Re: how do i do incremental load using procedure [message #235305 is a reply to message #222315] Fri, 04 May 2007 17:12 Go to previous messageGo to next message
cesar_winston
Messages: 1
Registered: May 2007
Location: MEXICO, CITY
Junior Member

another option is using sequences in the procedure...
Re: how do i do incremental load using procedure [message #235629 is a reply to message #235305] Mon, 07 May 2007 08:28 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
Replying to a two month old thread is probably not going to be much help, especially with a response like that. Let's put it to sleep.
Previous Topic: like in sql
Next Topic: Re: how can i PASS TABLE NAME AS PARAMETER IN PROCEDURE
Goto Forum:
  


Current Time: Sat Dec 10 03:01:48 CST 2016

Total time taken to generate the page: 0.11070 seconds