08-Transaction-Complex.txt

declare

 V_PRODUCTID number:=123;
 V_SALESPRICE number;

begin
 
  insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('�r�n A',310.0);

  savepoint S_AFTER_FIRST;

  insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('�r�n B',320.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 to S_AFTER_FIRST;


  insert into PRODUCT (PRODUCTNAME, SALESPRICE) values ('�r�n C',330.0);
  
  commit;

end;