摘要:
-- Create table create table DEPT2 ( DEPTNO NUMBER(2) not null, DNAME VARCHAR2(14), LOC VARCHAR2(1000) ); alter table DEPT2 add constraint DEPT_PK primary key (DEPTNO); ------demo.c... 阅读全文
摘要:
create or replace directory MY_DIR as '/home/oracle/backup'; grant read,write on directory MY_DIR to public; drop directory MY_DIR; -- Data Pump Unload drop table all_objects_unload purge; --将表卸载成文... 阅读全文
摘要:
-- Flat File Unload create or replace package unloader AUTHID CURRENT_USER as /* Function run -- unloads data from any query into a file and creates a control file to ... 阅读全文