Home » Infrastructure » Unix » how can we run sql commands from unix operating systems
how can we run sql commands from unix operating systems [message #262618] Mon, 27 August 2007 22:00 Go to next message
kumar.bethamcherla
Messages: 5
Registered: August 2007
Junior Member
No Message Body
Re: how can we run sql commands from unix operating systems [message #262626 is a reply to message #262618] Mon, 27 August 2007 23:02 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

You have use a client software. like SQL*PLUS.
Re: how can we run sql commands from unix operating systems [message #262674 is a reply to message #262618] Tue, 28 August 2007 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlplus user/passwd <<EOF
the SQL commands
EOF

Regards
Michel
Re: how can we run sql commands from unix operating systems [message #262852 is a reply to message #262674] Tue, 28 August 2007 06:46 Go to previous message
shahnazurs
Messages: 240
Registered: June 2005
Location: India
Senior Member
If you don't some connection related information then you can go for

sqlplus -s username/password<<!
--sql commands
!

s for silent
Thanks.
Previous Topic: Problems with Installation of Oracle 10g on Solaris 5.10 x86
Next Topic: need to display sql messages to screen when running from unix shell
Goto Forum:
  


Current Time: Wed Jul 30 18:44:02 CDT 2014

Total time taken to generate the page: 0.08662 seconds