Oracle导出数据中的prompt，set feedback 等是什么意思
- prompt
输出提示 - set feedback off
用于关闭输出提示信息，当有大量执行语句时候，往往会关闭"输出提示信息功能"，此时就会用到set feedback off set define off
用于替代变量：在SQLPlus中默认的"&"表示替代变量，只要在命令中出现该符号，SQLPlus就会要你输入替代值;
因此如果我们输入的命令中如果包含该字符，就要进行设置(关闭替代变量功能)实例代码
prompt PL/SQL Developer import file
prompt Created on 2017年11月11日 by Administrator
set feedback off
set define off
prompt Creating SYS_DEPARTMENT…
create table SYS_DEPARTMENT
(
id NUMBER not null,
is_deleted VARCHAR2(1) default 'n',
gmt_create DATE default SYSDATE,
creator VARCHAR2(32),
gmt_modify DATE,
modifier VARCHAR2(32),
parent_id NUMBER,
dept_name VARCHAR2(64),
dept_type VARCHAR2(10),
tel VARCHAR2(32),
fax VARCHAR2(32),
address VARCHAR2(512),
org_code VARCHAR2(12),
sort_num NUMBER,
is_system VARCHAR2(1),
full_id_path VARCHAR2(256),
full_name_path VARCHAR2(2048),
is_leaf VARCHAR2(1) default 'y',
org_level NUMBER,
gmt_deleted DATE
)
tablespace SMB_DATA
pctfree 10
initrans 1
maxtrans 255;
comment on table SYS_DEPARTMENT
is '部门表';
comment on column SYS_DEPARTMENT.is_deleted
is '删除标记 n 未删除 y 删除';
comment on column SYS_DEPARTMENT.parent_id
is '上级部门id';
comment on column SYS_DEPARTMENT.dept_name
is '部门名称';
comment on column SYS_DEPARTMENT.address
is '地址';
comment on column SYS_DEPARTMENT.sort_num
is '排序';
comment on column SYS_DEPARTMENT.is_system
is '是否系统预设部门 预设部门不能删除 ‘y’ 是 ‘n’ 否';
comment on column SYS_DEPARTMENT.full_id_path
is 'id完整路径 以''/''记录树节点的id路径 格式 1/2/5';
comment on column SYS_DEPARTMENT.full_name_path
is '以''/''记录树节点的dept_name路径 如：杭州市对外经济贸易合作局/外促出';
comment on column SYS_DEPARTMENT.is_leaf
is '是否叶子节点';
comment on column SYS_DEPARTMENT.org_level
is '等级';
comment on column SYS_DEPARTMENT.gmt_deleted
is '删除时间';
alter table SYS_DEPARTMENT
add constraint PK_SYS_DEPARTMENT primary key (ID)
using index
tablespace SMB_DATA
pctfree 10
initrans 2
maxtrans 255;
set feedback on
set define on