/********************************************************************************************
-- 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;