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 Functioncreate 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;
