SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

selecting null values into variables

439412Oct 19 2005 — edited Oct 19 2005

Hi,
I have a select into statement,

select field1 into v_field1 from sample_table where condition1

assume that i always get a maximum of only one row, now suppose my select statement returns no rows, then i get an oracle exception, now is there anyway of copying null value into the variable v_field1, without using count(*) or exception handling???

cheere

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 16 2005

Added on Oct 19 2005

9 comments

4,721 views