Shulou(Shulou.com)06/01 Report--

The file $ORACLE_HOME/sqlplus/admin/glogin.sql can set the environment variable after logging in to sqlplus

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.