Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query to find out rows deleted from a table

ORA_AJDec 8 2009 — edited Oct 19 2010
Hi

Suppose i have a table with a sequence i.e its an header table containing GRN nos.Now suppose someone has deleted some of serials from it like i am having 1,2,4,5,6 etc 3 is missing.Now what will be the query to find out what are the serials that are missed out in the table.


--Ajay Sharma

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 16 2010
Added on Dec 8 2009
9 comments
18,896 views