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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- No appropriate protocolAPPProtocol
- pytorch 轉 tensorRT 踩的幾個小坑_tensorrt engine set up failedPyTorchAI
- 825. Friends Of Appropriate AgesAPP
- man -k : nothing appropriate.APP
- [LeetCode] 825. Friends Of Appropriate AgesLeetCodeAPP
- [Bash] Environment variables
- Oracle environment variableOracle
- MyBatis-03-environmentMyBatis
- Get Oracle Environment InformaticaOracleORM
- Spring系列.Environment介面Spring
- ORA-12519 TNS:no appropriate service handler foundAPP
- 獎金up up up!單個漏洞最高獎勵2萬元!
- error: externally-managed-environmentError
- swiftUI-@Environment的作用SwiftUI
- Linux: Desktop Environment DE GUILinuxGUI
- Level Up
- wake up
- 備份時報no channel allocated for maintenance(of an appropriate type)AINaNAPP
- CS540 Python Virtual EnvironmentPython
- 17-Containers-Container Environment VariablesAI
- Qt QML之 JavaScript Host EnvironmentQTJavaScript
- day day up
- Lecture 05 Real-time Environment MappingAPP
- GitLab 實現動態 Environment URLGitlab
- Oracle案例03——RMAN-06091: no channel allocated for maintenance (of an appropriate type)OracleAINaNAPP
- E. Level Up
- Set
- set /?
- lombok get/set 與 JavaBean get/setLombokJavaBean
- ALi CTF 2015 write up
- up主進軍之路
- clean_up_log.sh
- [Javascript] Perform Set Operations using JavaScript Set MethodsJavaScriptORM
- set -e
- Jet Set
- set -o
- PVE(Proxmox Virtual Environment) 安裝配置iStoreOS筆記筆記
- Environment Switcher 原理解析(註解、Apt、反射、混淆)APT反射
- NSSCTF Web 題解 Write upWeb