You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 2010-05-07 15:04:20
- slacking
- Member
- Registered: 2010-05-06
- Posts: 2
Connecting to Oracle DB from Bash script.
Hello,
Not sure if this the place to post but I am a n00b to Arch.
Anyway I am looking at connecting to an Oracle DB to query some numbers.
I have looked in the wiki and found the how to install Oracle in Arch but all I want to do is connect to a DB not install one on Arch.
Can anyone point me in the direction of what to do.. I appreciate the help
Offline
#2 2010-05-08 00:05:39
- ssjlegendx
- Member
- Registered: 2008-01-01
- Posts: 94
- Website
Re: Connecting to Oracle DB from Bash script.
The command-line client often used with Oracle is SQL*Plus.
I don't know if you have it installed or not; but sqlplus can be invoked in a BASH script. You can pass SQL to it via an external file or a heredoc (i.e., standard input). (It might accept a string of SQL as part of the command, but I'm not sure.)
#!/vim/rocks
Offline
#3 2010-05-10 14:34:36
- slacking
- Member
- Registered: 2010-05-06
- Posts: 2
Re: Connecting to Oracle DB from Bash script.
Great, That is exactly what I was looking for.. now is there an arch build or somewhere I can grab the source. I just want the command line not the gui.. Thanks !
Offline
#4 2010-05-10 23:41:33
- ssjlegendx
- Member
- Registered: 2008-01-01
- Posts: 94
- Website
Re: Connecting to Oracle DB from Bash script.
Great, That is exactly what I was looking for.. now is there an arch build or somewhere I can grab the source. I just want the command line not the gui.. Thanks !
It might be included in whatever Oracle package you have installed; otherwise, check out the AUR packages here.
#!/vim/rocks
Offline
Pages: 1