Running a SQL using sqlplus in UNIX?

Question

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 dispalys connected to SQL, SQL> 1 2 .... How can I prevent these entries from getting printed?

What's the difference between this question and stackoverflow.com/questions/4655018 ? — Codo
– Codo, Commented Jan 11, 2011 at 7:51
possible duplicate of Suppress the contents of the SQLplus command in UNIX? — Dave Costa
– Dave Costa, Commented Jan 11, 2011 at 14:50

Codo · Accepted Answer · 2011-01-11 07:50:15Z

2

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

> sqlplus -s username/password@database

answered Jan 11, 2011 at 7:50

Codo

79.7k18 gold badges176 silver badges218 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ravibhushan Kumar Over a year ago

thanks sqlplus -s user/password@instance as sysdba @file.sql this command is working

Erich Kitzmueller · Accepted Answer · 2011-01-11 08:23:03Z

0

if everything else fails, you could try

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

answered Jan 11, 2011 at 8:23

Erich Kitzmueller

37k5 gold badges85 silver badges104 bronze badges

1 Comment

Erich Kitzmueller Over a year ago

No. Redirecting stdout and stderr to /dev/null eliminates everything that is not spooled.

Collectives™ on Stack Overflow

Running a SQL using sqlplus in UNIX?

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related