echo exit | sqlplus username/password@host_ip:port/Service_name @SQLFILENAME
I want to execute set sqlbl on
before executing The SQLFILENAME
and also want that after executing SQLFILENAME
it should exit sqlplus
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community$SQLPLUS -S username/password@ip:port/servicename<< EOF
SQL-STATEMENTS
set sqlbl on
commit
EOF