Скачать или смотреть oracle 11g accept and define command sqlplus

1) accept
2) define
ACC[EPT] variablename [NUM[BER] | CHAR | DATE | BINARY_FLOAT | BINARY_DOUBLE] [FOR[MAT] format] [DEF[AULT] default] [PROMPT text|NOPR[OMPT]] [HIDE]




accept var1 date prompt 'type date: ' format 'dd/mm/yyyy' default '01/01/2020' ;
accept var1 char prompt 'type value: ' ;
accept var1 num/number format '999.999' default '000.00'
accept password char prompt 'type password' hide ;
accept var1 char format 'a20' --max character limit 20


sql script -
define var1=SALES
--accept var1 char prompt ' type value: ' ;
--select * from dept where dname like '&var1';
select * from dept where dname like '%&var1%';






define var1=value ---it is also used to change environment variable


to change your environment variable parmanently -
edit file -- /u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/glogin.sql