Deleting 25 rows in Oracle

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Wed Jul 02, 2008 3:41 am

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?

Govindarajan · Post by **Govindarajan** » Wed Jul 02, 2008 4:38 am

How do you define this first 25 rows? based on any key column or date and time of record creation?

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Wed Jul 02, 2008 5:44 am

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..

bikan · Post by **bikan** » Wed Jul 02, 2008 6:03 am

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

keshav0307 · Post by **keshav0307** » Wed Jul 02, 2008 8:02 am

Lavanya ---what is your thought on this, what did you tried? have you created any job for it? what is that job doing?

LavanyaRamesh007 · Post by **LavanyaRamesh007** » Fri Jul 04, 2008 4:08 am

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

DSXchange

Deleting 25 rows in Oracle

Deleting 25 rows in Oracle

Re: Deleting 25 rows in Oracle

Re: Deleting 25 rows in Oracle