Define name : define « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. define
SQL>
SQL> define table_name="&1";
Enter value for 1: set linesize 78;
SQL> prompt &table_name
set linesize 78;
SQL> desc &table_name
Usage: DESCRIBE [schema.]object[@db_link]
SQL> set linesize 1000;
SQL> undefine table_name
SQL>
SQL>








29.40.define
29.40.1.Define name
29.40.2.Define variable