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

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