Re: RowCount (does this exist)

E.G

Select empno, ename from emp
where rownum <= 10;

This limits your output to the 'first' 10 items. Depending on the complexity of your query, it may not behave as expected though.

M

rtm wrote in message <7j2mvt$9tt$1_at_s3000-01.magna.com.au>...
>Does Oracle have a rowcount variable that can be set (like Sql Server) so
>that you can limit the total number of rows returned by a query. Have a
>v.large table that users can build their own queries against via
>application... but if they screw it up then don't want 10's of 1000's of
>rows returned...
>
>any help greatly appreciated..
>
>(wheres the FAQ?)
>
>rtm
>
>
Received on Wed Jun 02 1999 - 03:01:42 CDT