Anonymous PL/SQL block - using SQL*Plus defined variables |
-- anonymous_block_sqlplus_vars.sql -- Anonymous PL/SQL block - using SQL*Plus defined variables accept var1 prompt 'Value: ' DECLARE xxx varchar2(20); BEGIN xxx:='&&var1'; dbms_output.put_line(xxx); END; / |