这种语法在sqlserver2000中不报错,谁试一下在oracle中是不是会报错呀.
--测试
create table a
(
a1 int,
a2 int
)
create table b
(
b1 int,
b2 int
)
insert into a select 1,11
insert into a select 2,12
insert into b select 1,31
insert into b select 3,32
--这样写竟然没有错误提示！！！
select * from a
where a1 not in (select a1 from b)
--这样写竟然没有错误提示！！！
select * from #a
where a1 = (select top 1 a1 from #b)
为什么呢？
[解决办法]
没有top
[解决办法]
insert into a select 1,11
改成 insert into a select 1,11 from dual
select * from #a
where a1 = (select top 1 a1 from #b)
改成
select * from #a
where a1 = (select a1 from #b where rownum = 1)
[解决办法]
没有#表,没有top
[解决办法]
肯定报错.
[解决办法]
ztoracle中临时表
1) ON COMMIT DELETE ROWS 定义了建立事务级临时表的方法.
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT DELETE ROWS;
2)ON COMMIT PRESERVE ROWS 定义了创建会话级临时表的方法.
CREATE GLOBAL TEMPORARY TABLE admin_work_area
(startdate DATE,
enddate DATE,
class CHAR(20))
ON COMMIT PRESERVE ROWS;
