SqlServer的Sql语句与Oracle的Sql语句的区别
请大家帮忙看看,下面的Sql在Oracle里运行有什么错误
1.
begin
if exists(select * from 表1) then
select 1 from dual;
else
select 0 from dual;
end if;
end;
2.
declare
Mcount number(1):=0;
begin
select count(*) into Mcount from 表2 where m_id=1;
if Mcount=0 then
select 1 from dual;
else
select 0 from dual;
end if;
end;