sqlplus handig

Page dimensions

Defaults in sqlplus zijn 14 rows x 80-chars.
Veranderen naar , eg, 60 rows x 132-chars, use:

set PAGESIZE 60;
set LINESIZE 132;

Column widths

column Location format A20;

To list your current column formats:

column;

To clear your current column formats:

clear columns;

To clear one specific column format:

column Location clear;

CSV files

One way to create comma-separated or tab-separated files is to spool them from within sqlplus.
First set up neutral formatting:

SET PAGESIZE 0
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 80
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET MARKUP HTML OFF SPOOL OFF
SET COLSEP ','

Then

spool /tmp/output.csv
SELECT ...
spool off

RLWRAP

Zorg dat de volgende software geinstalleerd is.

yum install readline

yum install readline-devel

Download the latest rlwrap software

• http://utopia.knoware.nl/~hlub/uck/rlwrap/

Unzip and install the software using the following commands.

gunzip rlwrap*.gz
tar -xvf rlwrap*.tar
cd rlwrap*
./configure
make
make check
make install

In .bash_profile

alias rlsqlplus='rlwrap sqlplus'
alias rlrman='rlwrap rman'