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
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....