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

Report message to a moderator

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.

Report message to a moderator

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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
sqlplus user/passwd <<EOF
the SQL commands
EOF

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 21 20:10:55 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.