sql server语句如何转化为oracle语句

Question

sql server语句如何转化为oracle语句:

--sqlserver
declare @c int
select @c=count(*) from Employee
select @c,id,name from Employee

--如何转为oracle sql

Answer 1

 declare
c INTEGER;-- 定义的一个name变量
type rc is ref cursor; --定义游标
l_cursor rc;
begin 
SELECT count(1) INTO c FROM Employee;-- 变量赋值
open l_cursor for 'select '||c||',e.* from Employee e'; -- 开启游标查询
close l_cursor; -- 关闭游标
END;