Oracle导表语句
1,create table vincent_sms as select*from vincent_voice
创建一个表vincent_sms,其字段类型同vincent_voice完全一样,并会把vincent_voice中的记录也复制到vincent_sms表中去
注:select子句还可以加where限制条件
===================================================================
2,insert into vincent_sms select*from vincent_voice
将vincent_voice表中的记录导入vincent_sms表中
注:select子句还可以加where限制条件,如果vincent_sms和vincent_voice表结构不一样的话,当然可以指明字段的。注意,这里没有values关键字
分享到: