OraFAQ Forum: SQL & PL/SQL » Data extract from scheduled process improvement

Home » SQL & PL/SQL » SQL & PL/SQL » Data extract from scheduled process improvement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data extract from scheduled process improvement [message #617414]

Sun, 29 June 2014 12:25

ramraju20000
Messages: 8
Registered: September 2012

Junior Member

I Had an extract(ie that package is scheduled on every day) I got on this exract some data daily.

i need the data from next extract only new data not the data form yestdays date.

Please give me the suggestions.

[EDITED by LF: fixed topic title typos]

[Updated on: Sun, 29 June 2014 14:43] by Moderator

Report message to a moderator

Re: Data extarct from scheduled procees improvment [message #617415 is a reply to message #617414]

Sun, 29 June 2014 12:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

http://www.oracle.com/pls/db121/search?remark=quick_search&word=change+data++capture

Report message to a moderator

Re: Data extarct from scheduled procees improvment [message #617416 is a reply to message #617414]

Sun, 29 June 2014 12:54

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

ramraju20000 wrote on Sun, 29 June 2014 22:55

i need the data from next extract only new data not the data form yestdays date.

And what's that exactly? Is there any DATE parameter, if yes, then use SYSDATE to get only current day's data.

Report message to a moderator

Re: Data extarct from scheduled procees improvment [message #617417 is a reply to message #617414]

Sun, 29 June 2014 14:41

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

One possible implementation is the following one:
Create a new table that contains the date from which the data are to be extracted and change this date at the end of the job.

Report message to a moderator

Re: Data extarct from scheduled procees improvment [message #617418 is a reply to message #617417]

Sun, 29 June 2014 14:46

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Michel Cadot wrote on Sun, 29 June 2014 12:41

One possible implementation is the following one:
Create a new table that contains the date from which the data are to be extracted and change this date at the end of the job.

WHOOOSH is the sound of this idea zooming over the head & past this OP.

Report message to a moderator

Re: Data extarct from scheduled procees improvment [message #617501 is a reply to message #617418]

Mon, 30 June 2014 15:33

Bill B
Messages: 1971
Registered: December 2004

Senior Member

how about do the extract as a csv file that is attached as an external table. As soon as the extract is made, the data in the table will be the new data and none of the old. I use this method for extracts from ADP.

Report message to a moderator

Previous Topic:	Display output like.
Next Topic:	CURSOR FOR LOOP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 11:31:48 CDT 2024