Https://www.cnblogs.com/AmatVictorialCuram/p/5904914.html
- Prompt
Output hints
- Set Feedback off
Used to turn off the output hint information, when there are a large number of execution statements, often turn off the "Output information function", this time will be usedset feedback off
Set Define Off
For substitution variables: theDefault "&" in SQL Plus represents an alternative variable, and as long as the symbol appears in the command, SQLPlus will ask you to enter an alternate value;
So if we enter a command that contains the character, set it (turn off the override variable function)
Instance Code
Prompt PL/SQL Developer import fileprompt Created on November 11, 2017 by Administratorset feedback offset define offprompt Crea Ting sys_department...create table sys_department (ID number not NULL, is_deleted VARCHAR2 (1) Default ' n ', Gmt_create date default sysdate, creator VARCHAR2 (+), gmt_modify date, modifier VARCHAR2 (+), Paren t_id number, Dept_name VARCHAR2 (+), Dept_type VARCHAR2 (+), tel VARCHAR2 (+), fax VARCHAR2 (+), address VARCHAR2 (+), Org_code VARCHAR2 (+), sort_num number, Is_system VARCHAR 2 (1), Full_id_path VARCHAR2, Full_name_path VARCHAR2 (2048), Is_leaf VARCHAR2 (1) Default ' Y ', org_level Number, gmt_deleted DATE) tablespace smb_data pctfree Initrans 1 maxtrans 255;comment on table sys_department Is ' department table '; Comment on column sys_department.is_deleted is ' delete tag n not deleted y delete '; Comment on column sys_department.parent_id is ' Parent department ID '; Comment on colUmn Sys_department.dept_name is ' department name '; Comment on column sys_department.address is ' address '; Comment on column sys_department . Sort_num is ' sort '; Comment on column Sys_department.is_system is ' whether the System Presets Department default department cannot remove ' y ' is ' n ' no '; Comment on column SY S_department.full_id_path is ' ID full path with '/' Record tree Node ID path format 1/2/5 '; Comment on column Sys_department.full_name_path is ' to ' '/' records the dept_name path of tree nodes such as: Hangzhou foreign Economic and Trade Cooperation Bureau/external Promotion '; Comment on column sys_department.is_leaf is ' whether leaf node '; Comment on column Sys_de Partment.org_level is ' rank '; Comment on column sys_department.gmt_deleted is ' delete time '; ALTER TABLE sys_department add CONSTR Aint pk_sys_department primary KEY (ID) using index tablespace smb_data pctfree 2 Initrans (Maxtrans 255;set feedb) ACK onset define on
What does prompt,set feedback in the Oracle Export data mean