Cauec,
pokud bys chtel pouzivat promenne v SQL, tak to muzes pouzivat jednoduse takhle:
SQL> DEFINE first = v$database
SQL> DEFINE second = v$instance
SQL> select name, status from &first,&second;
old 1: select name, status from &first,&second
new 1: select name, status from v$database,v$instance
NAME STATUS
--------- ------------
TEST OPEN
pro zobrazeni hodnoty si muzes vypsat jednotlive promenne:
SQL> DEFINE first
DEFINE FIRST = "v$database" (CHAR)
SQL> DEFINE second
DEFINE SECOND = "v$instance" (CHAR)