修改sqlplus的SQLPROMPT

记着备用

[@more@]

alter session set nls_date_format='hh24:mi:ss';
col login_info_temp new_value login_info
select UTL_INADDr.get_host_name login_info_temp from dual;
SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER _DATE &login_info SQL>"

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

转载于:http://blog.itpub.net/79686/viewspace-1040363/