This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
info:oracle:sqlplus_scripting [2013-02-04 22:17] 127.0.0.1 external edit |
info:oracle:sqlplus_scripting [2013-03-01 20:30] (current) andunix |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Oracle: SQLplus Scripting ====== | ====== Oracle: SQLplus Scripting ====== | ||
| - | This page was moved to http:// | + | |
| + | To show only data in SQLplus and no header or other stuff, enter the following: | ||
| + | |||
| + | <code sql> | ||
| + | SET NEWPAGE 0 | ||
| + | SET SPACE 0 | ||
| + | SET LINESIZE 80 | ||
| + | SET PAGESIZE 0 | ||
| + | SET ECHO OFF | ||
| + | SET FEEDBACK OFF | ||
| + | SET VERIFY OFF | ||
| + | SET HEADING OFF | ||
| + | SET MARKUP HTML OFF SPOOL OFF | ||
| + | </code> | ||
| + | |||
| + | {{tag>oracle | ||