 Print
 Add To Favorites
 Email To Friend
 Rate This Article
|
CodeSnip: How to Select the Records from a Table Following a Pattern without Using ROWNUM
|
Published:
14 Apr 2008
|
Abstract
In this article Deepankar discusses how to select records from an Oracle 9i table without using ROWNUM. Deepankar provides a detailed analysis of each SQL statement along with the screenshot of the final output. |
 |
by Deepankar Sarangi
Feedback
|
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days):
20636/
44
|
|
|
|
| Introduction |
This code snippet is an extension of my earlier code snip How to select the records from a table following a pattern.
There I used ROWNUM to find the even/odd records from the emp table. Current
code snip achieves the same functionality even without the use of ROWNUM. This
method proves useful when it is asked to avoid the use of ROWNUM.
|
|
|
|
User Comments
No comments posted yet.
|
Product Spotlight
|
|
|
