SQL select into

I have a lot of select into
query's

[Quoted] [Quoted] If U make a select into and there are no records

[Quoted] U got the error ORA-01403: no data found

so I do first a

select count (....)
into counter
...

if counter = 1 then
  select .....
  into
  .....
end if;

Now im wondering if there is a better solution then the way I do it......sure is.....

like do it all in one step

Thanks Greg Received on Wed Sep 27 2000 - 10:13:44 CEST