Anonymous
public text v1 · immutableSQL> set linesize 2000
SQL> show all
appinfo is ON 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
markup HTML OFF SPOOL OFF ENTMAP ON PREFORMAT OFF
echo OFF
editfile "afiedt.buf"
embedded OFF
escape OFF
FEEDBACK ON for 6 or more rows
flagger OFF
flush ON
heading ON
headsep "|" (hex 7c)
instance "local"
linesize 2000
lno 15
loboffset 1
logsource ""
long 80
longchunksize 80
newpage 1
null ""
numformat ""
numwidth 10
pagesize 14
PAUSE is OFF
pno 8912
recsep WRAP
recsepchar " " (hex 20)
release 902000700
repfooter OFF and is NULL
repheader OFF and is NULL
serveroutput OFF
shiftinout INVISIBLE
showmode OFF
spool OFF
sqlblanklines OFF
sqlcase MIXED
sqlcode 0
sqlcontinue "> "
sqlnumber ON
sqlprefix "#" (hex 23)
sqlprompt "SQL> "
sqlterminator ";" (hex 3b)
suffix "sql"
tab ON
termout ON
time OFF
timing OFF
trimout ON
trimspool OFF
ttitle OFF and is the first few characters of the next SELECT statement
underline "-" (hex 2d)
USER is "*****"
verify ON
wrap : lines will be wrapped
SQL> select * from film;
FILMID MAINTITLE PRODUCTIONYEAR
---------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- --------------
47615 Convoyeurs attendent, Les 1999
47632 Cook the Thief His Wife & Her Lover, The 1989
47740 Copacabana Palace 1962
47742 Copains du dimanche, Les 1958
47743 Copains, Les 1964
47749 Copie conforme 1946
47758 Coplan et la fili�re argentine 1991
47759 Coplan FX 18 casse tout 1965
47760 Coplan prend des risques 1964
47761 Coplan sauve sa peau 1967
47762 Coplan, agent secret FX 18 1964