09-Transaction-Simple.txt

declare

 V_PRODUCTID number:=123;
 V_SALESPRICE number;

begin
 

  insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('�r�n X',410.0);

  insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('�r�n Y',420.0);
  
  insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('�r�n Z',430.0);,
  
  select SALESPRICE into V_SALESPRICE from PRODUCT where PRODUCTID=V_PRODUCTID;

  dbms_output.put_line('Sat�� ederi: ' || to_char(V_SALESPRICE));

  exception
    when no_data_found then
      rollback ;

  
  commit;

end;