ORACLE：prompt、set feedback、set define

ORACLE：prompt、set feedback、set define

prompt PL/SQL Developer import file
prompt Created on 2017年7月7日 by admin
set feedback off
set define off
prompt Deleting BLSC.CONFIG_SMS...
delete from BLSC.CONFIG_SMS;
commit;
prompt Loading BLSC.CONFIG_SMS...
insert into BLSC.CONFIG_SMS (SMS_NO, SMS_TYPE, SMS_CONTEXT, SMS_REMARK, SMS_EX1, SMS_EX2, SMS_EX3, SMS_CLANNEL)
values ('birthday', '09', '亲爱的{0}{1}，真诚祝您生日快乐，{2}', null, null, null, null, null);
commit;
prompt 1 records loaded
set feedback on
set define on
prompt Done.

prompt：控制台输出。

示例：

SQL> prompt PL/SQL De