What does "first" mean to you? Remember that the records in relational
database systems are not guaranteed to be in any particular order.

-----Original Message-----
From: David NGUYEN
[mailto:oracledba-ezmlmshield-x93988314.[Email address protected]
Sent: Tuesday, November 28, 2006 7:54 AM
To: LazyDBA Discussion
Subject: Spam: 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





THE INFORMATION CONTAINED IN THIS E-MAIL MESSAGE AND ANY ATTACHMENTS SENT FROM GENTEX CORPORATION IS GENTEX CONFIDENTIAL INFORMATION INTENDED ONLY FOR THE PERSONAL USE OF THE INDIVIDUAL OR ENTITY NAMED ABOVE. If you are not the intended recipient, you are hereby notified that any review, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender by return e-mail, and delete this e-mail message and any attachments from your computer.



Oracle LazyDBA home page