bhaileem

 Profile Answers by bhaileem 

• May 27th, 2009

 

sqlplus $DBA_userid '/'$DBA_passwd@oracle_sid .

wow_suraj

 Profile Answers by wow_suraj 

• Jun 17th, 2009

 

1> #!/bin/ksh
2>
3> sqlplus /nolog < /dev/null
4>
5> connect USER/PASSWORD@DATABASENAME
6>
7> WHENEVER SQLERROR EXIT 5
8> WHENEVER OSERROR EXIT 10
9>
10> @ONE.sql
11>
----------------------------------------------
given snippet will connect to the database--line # 3 n 5
and sql script (ONE.sql) will be executed-- line #10

However, other methods are also there to connect to the database
----------------------------------------------
sqlplus -s USER/PASSWORD@DATABASE << ENDSQL

sqlplus -S USER/PASSWORD@DATABASE <<-! 2>&1
----------------------------------------------

karthikeyan113

 Profile Answers by karthikeyan113 

• May 30th, 2010

 

You can connect to database with following snippet.

${ORACLE_HOME}/bin/sqlplus -s ${ORA_UID}/${ORA_PWD}@${ORACLE_SID}  << EOF!
...
database commands...
...
EOF!

Gunjan David

 Profile Answers by Gunjan David Questions by Gunjan David

• Jun 27th, 2011

 

sqlplus -s scott/tiger << abc
spool on ;
spool david;
select * from emp;
spool off;
exit;
abc

NARESH

• Jul 31st, 2011

 

sqlplus -s username/password@schema name
:wq

Ashutosh Gupta

• Sep 10th, 2011

 

in vi editor
vi connect.sh
#!/bin/bash

sqlplus -s sys as sysdba < startup
spool on;
spool ashu;
connect scott/tiger
select * from emp;
spool off;
exit;
EOF
cat ashu