用PL/SQL Developer会很方便的
tool -〉tableexport -〉SQL插入
可以生成你需要的sql语句。
例如:
prompt PL/SQL Developer import file
prompt Created on 2004年10月14日 by CHIN-K
set feedback off
set define off
prompt Creating TREE...
create table TREE
(
ID NUMBER not null,
PID NUMBER,
NAME VARCHAR2(100),
ORDERNUM NUMBER
)
;
alter table TREE
add constraint TREE_ID primary key (ID);
alter table TREE
add constraint TREE_PID foreign key (PID)
references TREE (ID) on delete cascade;prompt Disabling triggers for TREE...
alter table TREE disable all triggers;
prompt Disabling foreign key constraints for TREE...
alter table TREE disable constraint TREE_PID;
prompt Loading TREE...
insert into TREE (ID, PID, NAME, ORDERNUM)
values (0, 0, 'root', null);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (1, 0, 'a', 1);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (3, 0, 'c', 2);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (4, 1, 'aa', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (5, 1, 'ab', 4);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (6, 1, 'ac', 1);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (8, 3, 'ca', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (9, 4, 'aaa', 4);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (10, 4, 'aab', 5);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (11, 4, 'aac', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (12, 4, 'aad', 2);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (13, 9, 'aaaa', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (14, 9, 'aaab', 2);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (15, 9, 'aaac', 5);
commit;
prompt 14 records loaded
prompt Enabling foreign key constraints for TREE...
alter table TREE enable constraint TREE_PID;
prompt Enabling triggers for TREE...
alter table TREE enable all triggers;
set feedback on
set define on
prompt Done.
tool -〉tableexport -〉SQL插入
可以生成你需要的sql语句。
例如:
prompt PL/SQL Developer import file
prompt Created on 2004年10月14日 by CHIN-K
set feedback off
set define off
prompt Creating TREE...
create table TREE
(
ID NUMBER not null,
PID NUMBER,
NAME VARCHAR2(100),
ORDERNUM NUMBER
)
;
alter table TREE
add constraint TREE_ID primary key (ID);
alter table TREE
add constraint TREE_PID foreign key (PID)
references TREE (ID) on delete cascade;prompt Disabling triggers for TREE...
alter table TREE disable all triggers;
prompt Disabling foreign key constraints for TREE...
alter table TREE disable constraint TREE_PID;
prompt Loading TREE...
insert into TREE (ID, PID, NAME, ORDERNUM)
values (0, 0, 'root', null);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (1, 0, 'a', 1);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (3, 0, 'c', 2);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (4, 1, 'aa', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (5, 1, 'ab', 4);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (6, 1, 'ac', 1);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (8, 3, 'ca', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (9, 4, 'aaa', 4);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (10, 4, 'aab', 5);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (11, 4, 'aac', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (12, 4, 'aad', 2);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (13, 9, 'aaaa', 3);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (14, 9, 'aaab', 2);
insert into TREE (ID, PID, NAME, ORDERNUM)
values (15, 9, 'aaac', 5);
commit;
prompt 14 records loaded
prompt Enabling foreign key constraints for TREE...
alter table TREE enable constraint TREE_PID;
prompt Enabling triggers for TREE...
alter table TREE enable all triggers;
set feedback on
set define on
prompt Done.
解决方案 »
- 在sql里怎么把一个数值型的字段中小数点后的数值取出来?
- 麻烦各位高手了!!!!帮忙看看到底那里出错了
- oracle 怎样实现合并相同行 希望是 一条语句
- oracle 中 多表查询后产生的新表 的属性 和原表属性 一样嘛?
- 菜鸟问题:怎样写调用函数的SQL文
- Oracle数据库建好后,各种类型的表空间还要自已再建吗?或者说什么情况下自已才去创建?
- 十里开源最新决策『十里开源__http://www.opensource.com.cn』
- 请问数据库设计有大家公认的工具吗?还是只是一些规范,用什么都可以
- select 语句求解
- 关于字符集的问题!弱水大哥能看看吗?
- 恢复删掉的表空间_关于数据库的恢复(发言就有分)
- oracle问题
麻烦大了。。vc里面怎么创建一个存储过程?
ado->execute可以执行一个存储过程。
还有办法通过脚本或其他方式创建表或存储过程不?
可以导库,但因为最终的两个库布一样。
而且不需要所有的表a
这一切我要在程序实现的阿.
不过shellexecute应该也行。怎么给exp传参呢。?
alter table table1 .....//在新表上增加索引、主键等;
insert into table1 as select .... from table2 where .....//将table2中的记录批量插入到新表table1中。
create table 的各个结构,主建呢。。
Dim gconn As New ADODB.Connection
Dim vSql As Stringgconn.ConnectionString = "..."
vsql=....
gconn.Execute vSql
gconn.Execute是执行已经存在的过程,
我要在ado创建一个过程阿。 bilily谢谢待会给分
CString sqlStr =GetStringFromSQLFile(sqlfile);
//CString ="CREATE OR REPLACE PROCEDURE ................"很多行。
command->Execute(NULL,NULL,adCmdText是不行的
Connection的也一样,它不能识别;号。
我现在用的要注册啊。