Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

Bind variables can even be referenced by SQL queries

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> SQL>  SQL> SELECT index_name   2    FROM user_indexes   3   WHERE table_name = :s_table_name; no rows selected SQL> SQL> SET SERVEROUTPUT ON SQL> BEGIN   2    DBMS_OUTPUT.PUT_LINE(:s_table_name);   3  END;   4  / emp PL/SQL procedure successfully completed. SQL>