Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

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>