oracleFunctioin

OracleFunction 无 create or replace function get_userreturn varchar2 isResult_user varchar2(50);begin select username into Result_user from user_users;return Result_user;end get_user;drop function get_user调用:SQL var Re varchar2(50)SQL ;SQ

Oracle Function <无>

create or replace function get_user
return  varchar2 
is
Result_user varchar2(50);
begin 
select  username into Result_user from user_users;
return Result_user;
end get_user;
drop function get_user

调用:
SQL> var Re varchar2(50)
SQL> ;
SQL> exec :re:=get_user;
 
PL/SQL procedure successfully completed
Re
---------
YPGJ
 

--oracle 存储过程的调用
declare 
Re varchar2(50);
begin
Re :=get_user();
dbms_output.put_line(Re);
end;
///
declare
  m                         number(6);
  begin
  dbms_output.put_line('请输入一个数字');
  m                         := &x;
  dbms_output.put_line     (m);
end;