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

Define name

   <source lang="sql">

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

Define variable

   <source lang="sql">

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