What does prompt,set feedback in Oracle Export data mean?

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.