设置PL/SQL环境变量

-----------设置环境
--1.
begin
dbms_application_info.set_client_info(103);
end;
--2.

select * from oe_order_headers_v
select * from oe_order_lines_v

--------------------------------
Tag: Userenv

select userenv('lang') from dual
select userenv('terminal') from dual
select userenv('client_info') from dual
select userenv('entryid') from dual
select userenv('isdba') from dual
select userenv('language') from dual
select userenv('sessionid') from dual
select userenv('LANG') from dual

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25264452/viewspace-717354/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25264452/viewspace-717354/