select with default

Hello,

i wonder if there is a way to make a pl/sql code like this:

	begin
		select FIELD into VAR from TABLE where CONDITION;
	exception
		when NO_DATA_FOUND then VAR := DEFAULT;
	end;

without exception handling, just in one line, straight and simple. I found that such sentenses arise very often and i suppose there should be a way to simplify this.

Thank you,
Igor

--
Igor Sereda,
ITC, Russia Received on Thu Apr 16 1998 - 10:09:26 CDT