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

Discover more from Srinimf

Subscribe now to keep reading and get access to the full archive.

Continue reading