修改sqlplus的SQLPROMPT
时间:2010-10-25 来源:wenaini
记着备用
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>"
相关阅读 更多 +