searching through at table [message #434805] |
Thu, 10 December 2009 20:48  |
shapik
Messages: 1 Registered: December 2009 Location: islamabad
|
Junior Member |
|
|
im new to pl/sql and need help
i want to search through a table column and check weather a sequence is broken which means i have to compare two consecutive entries in a column.
|
|
|
|
Re: searching through at table [message #434813 is a reply to message #434805] |
Thu, 10 December 2009 22:47  |
 |
delna.sexy
Messages: 941 Registered: December 2008 Location: Surat, The Diamond City
|
Senior Member |
|
|
You can do this by single SQL statement. No PL/SQL block is required.
What you can do is, sort all those record in particular order and compare two consicutive values of required column using LAG/LEAD function.
regards,
Delna
|
|
|