|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Want to learn/use SQLPLUS in shell script
Post 302453333 by Franklin52 on Wednesday 15th of September 2010 02:12:32 AM
09-15-2010
Hello!
Your question(s) could easily be answered by searching the Internet with Google. Google is your friend
Per forum rules, and the benefit of all users, please search the network and the forums before posting a question.
You can easily search the forums using our internal Google search engine or our advanced internal search engine. You can also search our huge UNIX and Linux database by user generated tags or search the database for unanswered questions and provide an answer.
Thank you.
The UNIX and Linux Forums
====================
Check this link:
ORACLE-BASE - Oracle Shell Scripting
Your question(s) could easily be answered by searching the Internet with Google. Google is your friend
Per forum rules, and the benefit of all users, please search the network and the forums before posting a question.
You can easily search the forums using our internal Google search engine or our advanced internal search engine. You can also search our huge UNIX and Linux database by user generated tags or search the database for unanswered questions and provide an answer.
Thank you.
The UNIX and Linux Forums
====================
Check this link:
ORACLE-BASE - Oracle Shell Scripting
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello friends,
I'm newly joined as a sys admin(solaris).I'm very mach intrest in shell scripting.I wont to start the from basic.like ex:-how to find a ipaddress,host id ,or redirect the output ...like this type of small script and how to write those scripts.
Any one give me a link to study the... (4 Replies)
Discussion started by: rjay.com
4 Replies
2. Solaris
Hello friends,:D
I want to learn shell scripting in solaris .so any one pls help me to give a link (URL)to study scirpting.
rgds,
jay (13 Replies)
Discussion started by: rjay.com
13 Replies
3. UNIX for Dummies Questions & Answers
i'm having real problems retrieving the returncode of my sqlplus-call. I found a lot of informations on the net, but havn't been able to get it running so far, so now i ask for some help ;)
I do start the sqlplus out of my shell script with the parameters stored in the proc_clips.sql, which is... (6 Replies)
Discussion started by: maco_home
6 Replies
4. Shell Programming and Scripting
Can anybody help me out in sending parameters from sql*plus script to unix shell script without using flat files..
Initially in a shell script i will call sql*plus and after getting some value from some tables, i want that variable value in unix shell script. How can i do this?
Please tell me... (2 Replies)
Discussion started by: Hara
2 Replies
5. Shell Programming and Scripting
Hi,
I need help urgently for following issue. Pls help me to resolve this issue.
I am calling sql script file(file1.sql) from UNIX Shell Script(script1.ksh) using sql plus and trying to create flat file that contains all records returned from SQL query in SQL script(file1.sql)
I given... (6 Replies)
Discussion started by: praka
6 Replies
6. Shell Programming and Scripting
Hi
I want to connect to the Oracle database using a username/password and get back the query result(a numeric value) in a variable, which I can then compare using a conditional.
Can anybody help me with this.
Thanks
Gaurav (4 Replies)
Discussion started by: gaurav_1711
4 Replies
7. Shell Programming and Scripting
sql_rows=`sqlplus -s / <<EOF
set heading off
set pagesize 1000
set tab off
set linesize 120 wrap off
column "Path" format a15
--column "No_Of_files" format a10
select tablespace_name, substr(file_name,1,instr(file_name,'/',1,2)) as "Path" , count(*) as "No_Of_files" from dba_data_files
... (7 Replies)
Discussion started by: desibabu
7 Replies
8. Shell Programming and Scripting
Hi
When I use sqlplus in shell script, I get sqlplus: command not found.
ORACLE_HOME is not set. How to set ORACLE_HOME in unix?
Thanks (3 Replies)
Discussion started by: vinoth_kumar
3 Replies
9. Shell Programming and Scripting
Hi All,
Please let me know what i am missing in the following code (part of my script)
Schemas=(AWQM WFCONTROLLER PROVCO PRISM)
for s in "${Schemas}"
do
sch="${s}_$tol"
if || ;then
echo "This is AD or TD region"
sqlplus -s $sch/$tpwd@$ttns <<EOF... (7 Replies)
Discussion started by: pvmanikandan
7 Replies
10. UNIX for Beginners Questions & Answers
Hi,
i am new to shell script,i have a algorithm but i am not able to write script for this!
we have to run one menu script for 100 times,in the first time we have to give options and after that execute.
1.enter option for write,in that we give address and data
2.enter the option for read,we... (1 Reply)
Discussion started by: y9ec629
1 Replies
LEARN ABOUT LINUX
httppower
httppower(8) powerman httppower(8) NAME
httppower - communicate with HTTP based power distribution units SYNOPSIS
httppower [--url URL] DESCRIPTION
httppower is a helper program for powerman which enables it to communicate with HTTP based power distribution units. It is run interac- tively by the powerman daemon. OPTIONS
-u, --url URL Set the base URL. INTERACTIVE COMMANDS
The following commands are accepted at the httppower> prompt: auth user:pass Authenticate to the base URL with specified user and password, using ``basic'' HTTP authentication which sends the user and password over the network in plain text. seturl URL Set the base URL. Overrides the command line option. get [URL-suffix] Send an HTTP GET to the base URL with the optional URL-suffix appended. post [URL-suffix] key=val[&key=val]... Send an HTTP POST to the base URL with the optional URL-suffix appended, and key-value pairs as argument. FILES
/usr/sbin/httppower /etc/powerman/powerman.conf ORIGIN
PowerMan was originally developed by Andrew Uselton on LLNL's Linux clusters. This software is open source and distributed under the terms of the GNU GPL. SEE ALSO
powerman(1), powermand(8), httppower(8), plmpower(8), vpcd(8), powerman.conf(5), powerman.dev(5), powerman-devices(7). http://sourceforge.net/projects/powerman powerman-2.3.5 2009-02-09 httppower(8)