SQL Plus Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. SQL Plus
  4. Bind variables can be declared in your SQLPlus script,Preface a bind variable with a colon to reference it in a PLSQL block
SQL>
SQL> SET ECHO ON
SQL> 
SQL> VARIABLE  s_table_name  varchar2(30)
SQL>
SQL> 
SQL> BEGIN
  2    :s_table_name := 'emp';
  3  END;
  4  /
PL/SQL procedure successfully completed.
SQL>