본문으로 바로가기

sqlplus 백스페이스 사용법 및 sqlplus 환경설정

category Util 2016. 9. 13. 14:09

sqlplus에서 백스페이스를가 동작하지 않고 ^H가 입력이 될때 두가지 방법


방법1

.bashrc .bash_profile, .profile 중 하나의 파일을 vi 편집기를 이용하여 아래 라인 추가 
stty erase ^H


방법2

$ORACLE_HOME/sqlplus/admin/glogin.sql 파일의 끝 부분에

host stty erase ^H 추가

로그아웃 후 재접속 또는 source <편집파일명> 한뒤 sqlplus 에서 백스페이스를 입력하면 잘되는 것을 확인할 수 있다. 



sqlplus의 환경설정 파일 보기


sqlplus 환경설정 파일 위치 : $ORACLE_HOME/sqlplus/admin/glogin.sql

sqlplus 의 설정변수 전체 보기 : SQL> show all

ed명령시 에디터 설정하기 : SQL> define_editor=vi


show all 항목

appinfo is OFF and set to "SQL*Plus"

arraysize 15

autocommit OFF

autoprint OFF

autorecovery OFF

autotrace OFF

blockterminator "." (hex 2e)

btitle OFF and is the first few characters of the next SELECT statement

cmdsep OFF

colsep " "

compatibility version NATIVE

concat "." (hex 2e)

copycommit 0

COPYTYPECHECK is ON

define "&" (hex 26)

describe DEPTH 1 LINENUM OFF INDENT ON

echo OFF

editfile "afiedt.buf"

embedded OFF

errorlogging is OFF

escape OFF

escchar OFF

exitcommit ON

colinvisible OFF

FEEDBACK ON for 6 or more rows

flagger OFF

flush ON

fullcolname OFF

heading ON

headsep "|" (hex 7c)

instance "local"

linesize 80

lno 14

loboffset 1

logsource ""

long 80

longchunksize 80

markup HTML OFF HEAD "<style type='text/css'> body {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;} p {font:10pt Arial,Helvetica,sans-serif; color:black; background:White;}table,tr,td {font:10pt Arial,Helvetica,sans-serif; color:Black; background:#f7f7e7; padding:0px 0px 0px 0px; margin:0px 0px 0px 0px;} th {font:bold 10pt Arial,Helvetica,sans-serif; color:#336699; background:#cccc99; padding:0px 0px 0px 0px;} h1 {font:16pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; border-bottom:1px solid #cccc99; margin-top:0pt; margin-bottom:0pt; padding:0px 0px 0px 0px;-

} h2 {font:bold 10pt Arial,Helvetica,Geneva,sans-serif; color:#336699; background-color:White; margin-top:4pt; margin-bottom:0pt;} a {font:9pt Arial,Helvetica,sans-serif; color:#663300; background:#ffffff; margin-top:0pt; margin-bottom:0pt; vertical-align:top;}</style><title>SQL*Plus Report</title>" BODY "" TABLE "border='1' width='90%' align='center' summary='Script output'" SPOOL OFF ENTMAP ON PREFORMAT OFF

newpage 1

null ""

numformat ""

numwidth 10

pagesize 14

PAUSE is OFF

pno 0

recsep WRAP

recsepchar " " (hex 20)

release 1201000200

repfooter OFF and is NULL

repheader OFF and is NULL

securedcol is OFF

serveroutput OFF

shiftinout INVISIBLE

showmode OFF

spool OFF

sqlblanklines OFF

sqlcase MIXED

sqlcode 0

sqlcontinue "> "

sqlnumber ON

sqlpluscompatibility 12.1.0

sqlprefix "#" (hex 23)

sqlprompt "SQL> "

sqlterminator ";" (hex 3b)

suffix "sql"

tab ON

termout ON

timing OFF

trimout ON

trimspool OFF

ttitle OFF and is the first few characters of the next SELECT statement

underline "-" (hex 2d)

USER is "SYS"

verify ON

wrap : lines will be wrapped

xmloptimizationcheck OFF