exit | ${ORACLE_HOME}/bin/sqlplus -L -S <user>/<password>@<connect identifier> @abc.sql
notes:
- config ORACLE_HOME
- -L = Attempts to log on just once, instead of reprompting on error. If you don't turn this flag on the script will hang on error like wrong login, wrong connect identifier
- -S = silent mode, suppresses the sqlplus banner, prompt, etc
- Exit command is for automatically exit sqlplus after running the sql script file, or you can put an exit (or quit) statement at the end of the sql script.
| Evernote helps you remember everything and get organized effortlessly. Download Evernote. |
