Re: limiting rows returned ?

Use rownum which is a variable counting the number of rows returned so far

e.g.

select * from table
where rownum < 2;

• will give you just one row returned (if one or more exist).