Re: Need Help with PL/SQL
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/01
Message-ID: <55cto1$7j2_at_newton.pacific.net.sg>#1/1
Date: 1996/11/01
Message-ID: <55cto1$7j2_at_newton.pacific.net.sg>#1/1
Use ROWNUM as your selection criteria.
use WHERE ROWNUM < 101.
This will list the first 100 rows. If you need to retrieve only 10 rows, use where rownum < 11 in your selection criteria
Hope this helps
N.Prabhakar
Socgen-Crosby Securities,
Singapore
Received on Fri Nov 01 1996 - 00:00:00 CET