|
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>
|