set up the appropriate environment
1、put the following file(login.sql) into $ORACLE_HOME;
2、set environment virable:SQLPATH=$ORACLE_HOME
3、the content of file(login.sql) as follows:
define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
define gname=idle
column global_name new_value gname
select lower(user) || || substr( global_name, 1,
decode( dot, 0, length(global_name), dot-1) ) global_name
from (select global_name, instr(global_name,'.') dot from global_name );
set sqlprompt '&gname> '
set termout on
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/38542/viewspace-1019363/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How to set up printers for GUI?GUI
- Set up the Android SDKAndroid
- Get Set Up to Help With Python Core DevelopmentPythondev
- set up different data screen(masterial master) for different userAST
- JPDA and Set up Tomcat for Remote DebuggingTomcatREM
- Docker 容器中“TERM environment variable not set.”問題解決Docker
- India Karnataka Government is prepared to set up textile parks in each districtGo
- [INS-06006] Passwordless SSH connectivity not set up
- No appropriate protocolAPPProtocol
- 解決-Dmaven.multiModuleProjectDirectory system property is not set. Check $M2_HOME environment...MavenProject
- Oracle12c - ORA-65093: container database not set up properlyOracleAIDatabase
- How to set up Software raid1 configuration on a running systemAI
- SEVERE:OUI-10037:Unable to set up inventory錯誤處理UI
- 825. Friends Of Appropriate AgesAPP
- Oracle environment variableOracle
- man -k : nothing appropriate.APP
- Get Oracle Environment InformaticaOracleORM
- Microsoft IT Environment Health ScannerROS
- The DB2 environmentDB2
- MyBatis-03-environmentMyBatis
- Spring系列.Environment介面Spring
- Setup python virtual environmentPython
- Quickly setup a stream environment.UI
- 備份時報no channel allocated for maintenance(of an appropriate type)AINaNAPP
- [LeetCode] 825. Friends Of Appropriate AgesLeetCodeAPP
- Qt QML之 JavaScript Host EnvironmentQTJavaScript
- Change the Archiving Mode in a RAC Environment
- 配好 Europa C++ EnvironmentC++
- Backing up the tailAI
- Incremental checkpoint up to RBAREM
- Gross up by wage typeROS
- ERROR FIX:- rpmdb: unable to join the environmentError
- Materialized Views in data warehouse environment (185)ZedView
- Linux: Desktop Environment DE GUILinuxGUI
- ORA-12519 TNS:no appropriate service handler foundAPP
- ORA-12519 TNS no appropriate service handler foundAPP
- ORA-12519, TNS:no appropriate service handler foundAPP
- ORA-12519: TNS:no appropriate service handler foundAPP