반응형

/********************************************************************************************
-- Title : [10g] 서버 정보 출력 뷰
-- Key word :
********************************************************************************************/

create or replace view sys.sp_server0
as
    select 'IP_ADDRESS' "NAME", sys_context('USERENV','IP_ADDRESS') "VALUE" from dual union all
    select 'DB_NAME', sys_context('USERENV','DB_NAME') from dual union all
    select 'OS_USER', sys_context('USERENV','OS_USER') from dual union all
    select 'NLS_TERRITORY', sys_context('USERENV','NLS_TERRITORY') from dual union all
    select 'NLS_CURRENCY', sys_context('USERENV','NLS_CURRENCY') from dual union all
    select 'NLS_CALENDAR', sys_context('USERENV','NLS_CALENDAR') from dual union all
    select 'NLS_DATE_FORMAT', sys_context('USERENV','NLS_DATE_FORMAT') from dual union all
    select 'NLS_DATE_LANGUAGE', sys_context('USERENV','NLS_DATE_LANGUAGE') from dual union all
    select 'NLS_SORT', sys_context('USERENV','NLS_SORT') from dual union all
    select 'v$version', banner from v$version union all
    select name, value from v$parameter;
-- select * from sys.sp_server0;

grant select on sp_server0 to public;

 

 

반응형

+ Recent posts