Supressing oracle banner

1
votes

Is there a way to avoid banner text that sqlplus shows on connecting. e.g.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

I want to goto prompt. Just want to avoid banner, rest every things is required, like feed back etc.

My requirement is for both 11g and 12c Oracle.

1
oracleoracle11gsqlplusoracle12c
@WernfriedDomscheit - that is the anwser, so please post it as such. - g00dy
If you want an interactive session - since you do want the prompt - is the banner really a problem? - Alex Poole

1 Answers

2
votes

Run sqlplus -s ...

However, it also suppress the prompt SQL>. I don't know a solution which does both: suppressing the banner but showing the prompt.