Oracle的一些命令
时间：2021-07-01 10:21:17
帮助过：2人阅读
SQL Developer import
file
prompt Created on 2016年4月18日
by cwkj
-yuxin
set feedback
off
set define
off
prompt Creating TEST_TABLE...
create table TEST_TABLE
(
ID VARCHAR2(
50)
not null,
START_DATE VARCHAR2(
50),
END_DATE VARCHAR2(
50),
NAME VARCHAR2(
30),
TYPE VARCHAR2(
30),
PERSON_ID VARCHAR2(
30),
PERSON_NAME VARCHAR2(
30)
)
tablespace APPS_TS_TX_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 128K
next 128K
minextents 1
maxextents unlimited
pctincrease 0
);
prompt Disabling triggers for TEST_TABLE...
alter table TEST_TABLE disable
all triggers;
prompt Deleting TEST_TABLE...
delete from TEST_TABLE;
commit;
prompt Loading TEST_TABLE...
insert into TEST_TABLE (ID, START_DATE, END_DATE, NAME, TYPE, PERSON_ID, PERSON_NAME)
values (
‘01‘,
‘2016-04-18‘,
‘2016-05-07‘,
‘报销单‘,
‘报销‘,
‘001‘,
‘张三‘);
commit;
prompt 1 records loaded
prompt Enabling triggers for TEST_TABLE...
alter table TEST_TABLE enable
all triggers;
set feedback
on
set define
on
prompt Done.
Oracle的一些命令
标签：
