Oracle SQL query data store in a variable

To store sql query result into a variable sql syntax like this.

SET serveroutput ON;
declare 
rateId NUMBER(19,0);
BEGIN
select ID into rateId from TABLE_NAME where value = '1234';
DELETE from TABLE_NAME2 where id = rateId;
DBMS_OUTPUT.PUT_LINE('DELETED ROW=' || rateId);
EXCEPTION
  WHEN NO_DATA_FOUND THEN
    DBMS_OUTPUT.PUT_LINE ('No Rate found ' || rateId);
  WHEN OTHERS THEN
    DBMS_OUTPUT.PUT_LINE ('Unexpected error');
    RAISE;
end;