10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Discussion started by: vel4ever
2. Shell Programming and Scripting
I am a newbie.....am jus trying to connect to oracle thro a script, but not thro giving the username/password@server_name directly like
In the above line, once it is connected to Oracle, it shud ask me the username and password... (4 Replies)
Discussion started by: kritibalu
3. Shell Programming and Scripting
I am trying to connect to oracle database (126.96.36.199.0) through Sun solaris.
But I am unable to do so.
The content of my script is as follows:
RESULT=`$ORACLE_HOME/bin/sqlplus schema/'pwd'@db << EOF
set echo on;
set feedback on;
echo... (10 Replies)
Discussion started by: fidelis
4. Shell Programming and Scripting
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Discussion started by: mogabr
5. Shell Programming and Scripting
I am satyakiran , i am new to the forum. i never done shell scripts for connecting to the data base (oracle) and fetching the data from the database( thru sql select statements ) i want to know
1. how to connect to the data base(oracle) using shell script
2. how to retrieve data... (8 Replies)
Discussion started by: satyakiran
6. Shell Programming and Scripting
Could you please suggest me how to run a shell script on a solaris env without using crontab. I am actually trying to write a shell script which will grep "WORD" in the logfile andd sends a email.Thanks in advance.
Sandeep. (3 Replies)
Discussion started by: sandeep anand
7. Shell Programming and Scripting
I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Discussion started by: jsheehan223
8. Shell Programming and Scripting
I have the following code in my shell script.
sqlplus -s $DB_USER/$DB_PWD@$DB_NAME > xx.html <<EOF
I am passing DBuser and DBname from a config file and the password from user.
Config File :
I am getting... (1 Reply)
Discussion started by: dzyr4tt
9. Shell Programming and Scripting
this is urgent..can i run a shell script from store procedure without using java. (8 Replies)
Discussion started by: arnabb4u
10. UNIX for Advanced & Expert Users
Can some one help me in connecting to oracle through unix shell scripts with examples.
Narayana Gupta (1 Reply)
Discussion started by: guptan