oracle控制语句学习一——if elsif else控制语句

declarev_count number(6,2);beginselect count(1) into v_count from communitytype twhere t.community_type_id = 'AcademicRes';if v_count > 1thendbms_output.put_line('查询到多条');elsif v_count > 0thendbms_output.put_line('查询一条');elsedbms_output.put_line('失败');end if;end;