select * into a from a..a 请问,这句中的a....有什么用a..是另一个库吗

select * into b from a where 11 select * into dept2 from dept insert into a select * from b 和select * into a from b 这两个语句是不是一样的? select * from a union select * from b 能详细说下么 数据库中select into from 和 insert into select的区别 select * into a from a..a 请问,这句中的a....有什么用a..是另一个库吗 PLSQL中复制表select * into b from a where 11这句话中where 11在这里怎么理解 insert into a (select * from b)和把记录取出来然后分别insert那个的效率高? select * from (select a.*,rownum aa from table a ) where aa=10 select *from A where A.a like '%1%'||'%' Please select a city or zipcode from the drop-down. Please select a plan from the options to the select * from book limit , select id from (select id from pedigree group by number having count(name)>1)as a; 为啥用as a select c.*,d* from ( select 图号 from ( SELECT a.*,b.存货编码 FROM 未明图号 as a left OUTER JOIN 存select c.*,d* from ( select 图号 from (SELECT a.*,b.存货编码FROM 未明图号 as a left OUTER JOIN 存货档案 as bON a.图号=b.规 oracle 中select into是什么意思把一个表里面的内容复制到另一个吗 还是别的 是不是还要先创建一个表啊create table aaa as select * from bbb 这样的效果 用select into 能做到么? group by 和 distinct 的问题select a.partner as pcode, count(distinct(a.deviceid)) as count -- into num4 from test a where a.activationtime >= to_date('2011-4-17', 'yyyy-mm-dd') and a.activationtime < to_date( insert into REC_OVER(ORG_ID) select '1' from dual where not exists (select ORG_ID from REC_OVER )insert into REC_OVER(ORG_ID) select '1' from dual where not exists (select ORG_ID from REC_OVER ) 请问oracle里这样的语句,为什么在sql/plus可