我在Sqlserver中执行语句正常,不知道在Oracle中怎样实现类似功能SqlServer:
declare @Express numeric(18,2) set @Express=30*3 select @ExpressOracle:
declare Result numeric(18,2);
Begin
Select 3*3 Into Result From dual;
select Result from dual;
End ;
declare @Express numeric(18,2) set @Express=30*3 select @ExpressOracle:
declare Result numeric(18,2);
Begin
Select 3*3 Into Result From dual;
select Result from dual;
End ;
Begin
Select 3*3 Into Result From dual;
dbms_output.put_line(Result);
End ;
return Result
就行
RETURN NUMBER
is
Result number;
begin
Select 3*3 Into Result From dual;
return Result;
end test;
/
Begin
Select 3*3 Into Result From dual;
select Result from dual; --这条语句执行会出错,应该怎样修改
End ;=========================================================================
declare @Result numeric(18,2) set @Result =30*3 select @Result
在Sqlserver中 程序执行完上面语句后,可以取得 @Result的值 ,我就是想在oracle实现类似的功能
注是在程序中得到 Result的值,不是在DBMS中得到