$ORACLE_HOME/sqlplus/admin/glogin.sql 這個(gè)文件可以設(shè)置登錄sqlplus后的環(huán)境變量

創(chuàng)新互聯(lián)專(zhuān)注于企業(yè)營(yíng)銷(xiāo)型網(wǎng)站建設(shè)、網(wǎng)站重做改版、會(huì)同網(wǎng)站定制設(shè)計(jì)、自適應(yīng)品牌網(wǎng)站建設(shè)、html5、電子商務(wù)商城網(wǎng)站建設(shè)、集團(tuán)公司官網(wǎng)建設(shè)、外貿(mào)網(wǎng)站建設(shè)、高端網(wǎng)站制作、響應(yīng)式網(wǎng)頁(yè)設(shè)計(jì)等建站業(yè)務(wù)，價(jià)格優(yōu)惠性?xún)r(jià)比高，為會(huì)同等各大城市提供網(wǎng)站開(kāi)發(fā)制作服務(wù)。

set linesize 200 pagesize 100
col segment_name for a20
col table_name for a30
col instance_number for 999

-- Defaults for editor
define_editor = "vi"
-- set sqlprompt "&_connect_identifier>"

column plan_plus_exp format a80
column global_name new_value gname
set termout off

--select lower(user) || '@' ||
--case when instr(global_name,'.')>1
--then substr(global_name,1,instr(global_name,'.')-1)
--else global_name end
--global_name from global_name;

select lower(user) || '@' ||
case when instr(global_name,'.')>1
then substr(global_name,1,instr(global_name,'.')-1)
else global_name end || '@' || host_name
global_name from global_name, v$instance;

set sqlprompt '&gname> '

set termout on
set time on timing on