01-Variables-Simple.txt

declare
  
 V_PRODUCTID number;
 V_SALESPRICE PRODUCT.SALESPRICE%TYPE;
 V_PRODUCTNAME varchar(100);
 
begin

  V_PRODUCTID:=9;

  select PRODUCTNAME, SALESPRICE into V_PRODUCTNAME,V_SALESPRICE from Product where PRODUCTID=V_PRODUCTID ;

  dbms_output.put_line('�r�n ad�: ' || to_char(V_PRODUCTNAME ));
  dbms_output.put_line('Sat�� ederi: ' || to_char(V_SALESPRICE ));


end;