Page 1 of 1
Deleting 25 rows in Oracle
Posted: Wed Jul 02, 2008 3:41 am
by LavanyaRamesh007
Hi,
My requirement is such that the 1st 25 rows of oracle needs to be deleted everytime I run datastgae job to load Oracle. How do I achieve this?
Re: Deleting 25 rows in Oracle
Posted: Wed Jul 02, 2008 4:38 am
by Govindarajan
How do you define this first 25 rows? based on any key column or date and time of record creation?
Re: Deleting 25 rows in Oracle
Posted: Wed Jul 02, 2008 5:44 am
by LavanyaRamesh007
Govindarajan wrote:How do you define this first 25 rows? based on any key column or date and time of record creation?
Yes it is based on a Key Column FTRJ, which is a string..
Posted: Wed Jul 02, 2008 6:03 am
by bikan
you can first join with thay oracle table....then using column generator generate sequence number in dummy column..then take first 25 records and delete from oracle...other records can be passed to other stream for updation/iserion.
though I must say it's very strange requirement. :D
you can do it this in two jobs as well...
you can also manipulate how toselect record for deletion
Posted: Wed Jul 02, 2008 8:02 am
by keshav0307
Lavanya ---what is your thought on this, what did you tried? have you created any job for it? what is that job doing?
Posted: Fri Jul 04, 2008 4:08 am
by LavanyaRamesh007
keshav0307 wrote:Lavanya ---what is your thought on this, what did you tried? have you created any job for it? what is that job doing?
Well I am still doing it.. .. Shall keep you guys posted.. thanks for coming up with different ideas