Running a SQL using sqlplus in UNIX?

While running the SQL using sqlplus, I dodn't want to dispaly anything on the screen. I am using SPOOL to save the contents to a file. even if I redirect it dispaly开发者_开发知识库s connected to SQL, SQL> 1 2 .... How can I prevent these entries from getting printed?

Try the option -silent (or just -s):

> sqlplus -s username/password@database

if everything else fails, you could try

sqlplus username/password@database @myscript.sql >/dev/null 2>&1