10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
$ echo $SHELL
Requirement - How to pass oracle sql script as argument to unix shell script?
$ ./output.sh users.sql
Below are the shell scripts and the oracle sql file in the same folder.
$ cat output.sh
.... (7 Replies)
Discussion started by: a1_win
2. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
3. Shell Programming and Scripting
I am new to this unix world...I need your help to walk through.
I want to learn shell scripting..... The shell script which can be able to use with oracle pl/sql...
So please suggest me which shell is good.
Which Unix/Linux version is good for this to Install to get practice the... (8 Replies)
Discussion started by: GaneshAnanth
4. Shell Programming and Scripting
I use below command to log in to oracle database
sqlplus username/passwordWhen i enter into sql prompt i press quitIf there are any errors it will show just below the output of sqlplus username/password. The errors generally start with keyword ORA can we do this by using a unix shell script.?... (4 Replies)
Discussion started by: Nakul_sh
5. 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
6. Shell Programming and Scripting
Hi, can anyone help me with this script please. I need the oracle command to go into the unix batch file.
# A menu driven Shell script which has following options
# for acmtoron@>
# As per option do the job
echo " A C M LOG MONITORING... (0 Replies)
Discussion started by: tinaaguilera
7. Shell Programming and Scripting
I need to select one column from a table based upon the passed in parameter.
I tried this:
sqlplus -silent $MISP_USER << EOF
set feedback off;
set verify off;
set sqlprompt ""
WHERE job_name = '$1';
exit... (1 Reply)
Discussion started by: ganga.dharan
8. Shell Programming and Scripting
I have a shell script where I log on to sqlplus like this
sqlplus -s scott/tiger <<!
select count(*) from EMP;
Here I have hardcoded/used the username : scott and password : tiger directly to log on to SQLPLUS. If i have my log in information in my profile file... (2 Replies)
Discussion started by: manirsendhil
9. Shell Programming and Scripting
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Check if the network drive exists
Check... (0 Replies)
Discussion started by: sayydevara
10. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva