How to connect Oracle from UNIX

The following commands help you establish a connection between UNIX and ORACLE.

Top Commands to Establish Connection Between UNIX and ORACLE

echo “connecting to database”

sqlplus -s   /nolog   <<EOF

connect myid/mypwd;

Select * from all_users;

exit;

EOF

echo “disconnected”

In the end you need to give exit command to come out.

Related posts

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.