SQL> 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