常用的oracle指令

 select sys_context('userenv','host') from dual; 檢視主機名

select utl_inaddr.get_host_address from dual;檢視IP位址

(select banner from sys.v_$version where rownum=1),察看Oracle版本

select member from v$logfile where rownum=1 獲得作業系統版本

select instance_name from v$instance 獲得sid标示符

<a href="http://news.csdn.net/n/20061127/98323.html">http://news.csdn.net/n/20061127/98323.html</a>