1st row or nth row of the table

[vbaskar]

select 1,2,3,4,5 from tablex
where
rownum<=1
minus
select 1,2,3,4,5 from tablex
where
rownum<1

this will return 1st row and subsequently change the values for the N th row..

Rgds