-silent is used to eliminate the default display of Sql*plus and database version information   when the login Sql*plus is connected to the database, and also removes the display prompt. can be shortened to-sset pagesize 0 pagesize environment parameters are used to set the number of record lines displayed per page, pagesize 0 purpose is not to limit the number of records that can be displayed per page, so that the results of the query are not displayed in pages the side effect is that the column name of the table is not displayed in the query result line set feedback off does not show the number of record bars affected by SQL commands set heading off is used to specify that column names are not displayed in query results set verify off does not display confirmation information for variable values set echo off does not display script content set termout off is used to specify when SQL scripts are executed in Sql*plus. Execution results are not displayed.
Environment variables for sql*plus in shell scripts
