A A001 Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-03 #1 sql中，将一张表的某些数据copy到另一张表中怎么做，请教详细做法
K Kent Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-03 #2 insert into 数据库1(字段1，字段2，...字段n) select 字段1，字段2，...字段n from 数据库2 where 条件
C ctk Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-05 #3 用sql*plus的 copy [from user/password@datebase] [to user/password@database] {append|create|insert|replace} table [(column[,column]...)] using query;
用sql*plus的 copy [from user/password@datebase] [to user/password@database] {append|create|insert|replace} table [(column[,column]...)] using query;
P popeye Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-05 #4 tbatchmove,source用tquery选择符合条件的数据,dest为新表 可以设置为copy,append模式
A arm Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-05 #5 create table xxx select * from yyyy
G gongjan Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-05 #6 Insert into A_table (Select Field_1,Field_2,[Field_3...] From 注意:插入到A表的数据字段类别必须与SELECT 语句的类型完全相同.
N NCLP Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-06 #7 insert into NewTable (fiel1，fiel2，...fieln) select fiel1，fiel2，...fieln from sourceTable 其实在DELPHI 中还有一种方式更快, 使用BatchMove控件 from table1 for table2
insert into NewTable (fiel1，fiel2，...fieln) select fiel1，fiel2，...fieln from sourceTable 其实在DELPHI 中还有一种方式更快, 使用BatchMove控件 from table1 for table2
P ppz_76 Unregistered / Unconfirmed GUEST, unregistred user! 2000-05-09 #8 利用PL/SQL编写一个小程序 对TABLE1建立一个指针，然后循环向table2中加入
