02-Variables-Row.txt

declare

  V_PRODUCTID constant number:=9;
   
  R_PRODUCT PRODUCT%ROWTYPE;
 
begin

  select * into R_PRODUCT from Product where PRODUCTID=V_PRODUCTID ;

  dbms_output.put_line('�r�n ad�: ' || to_char(R_PRODUCT.PRODUCTNAME ));
  dbms_output.put_line('Sat�� ederi: ' || to_char(R_PRODUCT.SALESPRICE ));

end;