SQL> ed
  1  declare
  2   v_sum number;
  3  begin
  4   select sum(sal)
  5   into v_sum
  6   from emp
  7   where deptno in (-10,-20);
  8* end;
SQL> /

PL/SQL procedure successfully completed.

SQL> ed
Wrote file afiedt.buf

  1  declare
  2   v_sum number;
  3  begin
  4   select sum(sal)
  5   into v_sum
  6   from emp
  7   where deptno in (-10,-20)
  8   group by deptno;
  9* end;
SQL> /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 4

  Select to_date(max(d.created), 'DD.MM.YYYY')
    Into date_last
    From date_sync d
   Where d.table_name = 'PROFILE.INSERT'
     And d.error_text Is Null
   Group By table_name;

SQL> ed
Wrote file afiedt.buf

  1  declare
  2   v_sum number;
  3  begin
  4   begin
  5    select sum(sal)
  6    into v_sum
  7    from emp
  8    where deptno in (-10,-20)
  9    group by deptno;
 10   exception
 11   when no_data_found then
 12     v_sum:=null;
 13   when others then
 14    raise;
 15   end;
 16* end;
SQL> /

PL/SQL procedure successfully completed.

SQL> select to_char(max(sysdate)) d from dual;

D
------------------------------------
18(Вівторок) Липень 2017 9:3:44

SQL> ed
Wrote file afiedt.buf

  1* select to_date(max(sysdate),'dd.mm.yyyy') d from dual
SQL> /
select to_date(max(sysdate),'dd.mm.yyyy') d from dual
               *
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected


SQL>