Select * from tab1 where rownum < 1001

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x93988314.[Email address protected]
Sent: Tuesday, November 28, 2006 1:54 PM
To: LazyDBA Discussion
Subject: need a query or procedure..

hello experts,

i have a table tab1(col1,col2) , i just need to get the first 1000 rows

in this table , how to write this query ou procedure.?

thanks in advance.

david..


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html





NOTE: This e-mail message is subject to the MTN Cameroon disclaimer, see http://www.mtncameroon.net/disclaimer.html

Oracle LazyDBA home page