Home » SQL & PL/SQL » SQL & PL/SQL » i want to delete records (merged)
i want to delete records (merged) [message #226241] Fri, 23 March 2007 01:19 Go to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member

i have table its has 20000 records.

i want to delete 1000 to 2000 records.

thanks
srinivas
Re: i want delete records [message #226242 is a reply to message #226241] Fri, 23 March 2007 01:22 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
So? What is your problem?
Re: i want delete records [message #226244 is a reply to message #226242] Fri, 23 March 2007 01:28 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
how to delete
record no:1000 to record no:2000.

Re: i want delete records [message #226245 is a reply to message #226244] Fri, 23 March 2007 01:30 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
i have query

but its delete last records

select * from employee where rowid in
(select r from (select rowid r from employee order by rownum desc) where rownum<4)




but i want to delete
record no:1000 to record no:2000.
Re: i want delete records [message #226254 is a reply to message #226245] Fri, 23 March 2007 01:41 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Search the forum. There are plenty of threads regarding selecting records n to m.
i want delete records [message #226263 is a reply to message #226241] Fri, 23 March 2007 02:05 Go to previous message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
yes i got it Frank

delete from emp where rowid in (select rowid from (select e.*,row_number( ) over( order by empno ) r from
(select * from emp) e) where r between 5 and Cool

Thanks
srinivas
Previous Topic: Date calculation..effective ways
Next Topic: ORA-00600: internal error code,
Goto Forum:
  


Current Time: Sun Dec 11 08:02:33 CST 2016

Total time taken to generate the page: 0.05532 seconds