首先oracle里不适合你这个语法
oracle里复制表的语法是
create b as select * from a where 11
这里11 代表只复制表结构,而不复制里边的数据
因为11是个false,也就是为假,所以就不复制数据只复制表结构了
如果后边改成1=1,也就是个true,为真,就连数据带表结构一起复制了
PLSQL中复制表select * into b from a where 11这句话中where 11在这里怎么理解
1个回答
相关问题
-
SQL语句理解 select * from B where (select count(1) as num from A
-
求单表查询的hql语句怎么写sqL如下：select * from aaa20 where aaae2001 = '11
-
delete from A where a_id in (select id from B where b_id in
-
ms sql :select * from (select *from b) as xxx where 和 select
-
select 表列名1 into :变量名1 from 表名 where 表列名1=:变量名2; 这个语句怎么解释?
-
select * from v$locked_object a,user_objects b where a.OBJEC
-
存储过程中单引号中还有一个单引号该怎么办,如：exec('select * from tb where a='xx'')
-
select * from table_a a,table_b b where a.col1 = b.col1(+) ;
-
哪个spl操作语句不能带where条件句子?A.select查询句.B.insert into子
-
select A.a,b,c,d from A,B where A.a=B.a and f='1'