Oracle PL/SQL Tutorial/SQL PLUS Session Environment/define

Define name

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>

Define variable

SQL>
SQL> variable x number
SQL> variable y varchar2(8)
SQL>
SQL> execute :x := 7566
PL/SQL procedure successfully completed.
SQL> execute :y := "ADMIN"
PL/SQL procedure successfully completed.
SQL>
SQL> print x y
     X
------
  7566

Y
--------------------------------
ADMIN
SQL> variable
variable   x
datatype   NUMBER
variable   y
datatype   VARCHAR2(8)
SQL>
SQL>