功能:pl/sql执行本地的sql文件中的sql语句
说明:比如:e:/zhaozhenlong下有create_table.sql文件,则按如下方法执行:
步骤:
1、在pl/sql的command window下,
或在windows的开始/'运行'下,sqlplus /nolog; connect cs@orademo;
2、执行:
@@e:/zhaozhenlong/drop_table.sql
@@e:/zhaozhenlong/create_table.sql
/*
说明:.sql文件名字中不能有空格,
如create_table.sql是合法的,create table.sql是非法的。
文件内容:
drop_table.sql文件内容:
drop table tb_zhaozhenlong6;
drop table tb_zhaozhenlong5;
create_table.sql文件内容:
--drop table tb_zhaozhenlong5;
create table tb_zhaozhenlong5(
c1 varchar2(10) not null constraint pk_zhaozhenlong5 primary key,
c2 varchar2(10) not null ,
c3 varchar2(10) not null constraint un_zhaozhenlong5 unique,
c4 char(1) not null constraint ck_zhaozhenlongddd check(c4 in('0','1')) ,
c5 char(1) not null,
constraint un_zhaozhenlong51 unique(c1,c2),
constraint ch_zhaozhenlong51 check(c5 in('Y','N'))
);
--drop table tb_zhaozhenlong6;
create table tb_zhaozhenlong6(
c1 varchar2(10) not null, constraint fk_zhaozhenlong6 foreign key(c1) references tb_zhaozhenlong5(c1),
c2 varchar2(10) not null,
constraint pk_zhaozhenlong6 primary key(c1,c2)
);
alter table tb_zhaozhenlong6 drop constraint fk_zhaozhenlong6;
alter table tb_zhaozhenlong6 add constraint fk_zhaozhenlong6 foreign key (c1,c2) references tb_zhaozhenlong5(c1,c2);
*/