Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
ALL_SYNONYMS
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Hello,
I'm wondering if you may know of a simple file based UNIX utility that can be used to store and retrieve values on a flat file, let's say i have a file called "kru", i'd like to be able to specify a request like:
while(....)
if ; then
kru.fld2 = $rec_cnt
kru.fld3 =... (4 Replies)
Hi-
I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment...
I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Hello All,
We have a very old system at hand in which there are hundreds of shell scripts that use other shell scripts, all on the same server. There are several that are not used at all as well. In short, it's an unmanaged system thats been lying around for many years, and it needs to be... (12 Replies)
Hi,
I have a query ..
i have 2 scripts say 1.sh and 2.sh
1.sh contains many functions written using shell scripts.
2.sh is a script which needs to call the functions definded in 1.sh
function calls are with arguments.
Can some one tell me how to call the functions from 2.sh?
Thanks in... (6 Replies)
Hi
I am getting some errors when i am running the shell script using the following syntax:
>abc.sh
but the same script works fine with the following syntax:
>sh abc.sh
wats the difference in both....please help
thanks in advance. (6 Replies)
Hi,
Can anyone tell me how to call a oracle package from a Unix shell script? I want to pass some input parameters to package and it will return me the output which I want to use further in my shell script. I want to know the way to capture the output values in my shell script. Please send some... (1 Reply)
for example:
# I want to judge the value of $1 which should be $2<$1<$3.
temp0=`echo "$1 - $2" | bc`
temp1=`echo "$1 - $3" | bc`
if ] ; then
echo OK
else
echo False
fi
Please use code tags, thanks. (6 Replies)
Hi All,
I have a script which intends to create as many variables at runtime, as the number of parameters passed to it. The script needs to save these parameter values in the variables created and print them
abc.sh
----------
export Numbr_Parms=$#
export a=1
while
do
export... (3 Replies)
Discussion started by: dev.devil.1983
3 Replies
LEARN ABOUT DEBIAN
scsi_start
SCSI_START(8) SG3_UTILS SCSI_START(8)NAME
scsi_start - start one or more SCSI disks
SYNOPSIS
scsi_start [--help] [--verbose] [--wait] DEVICE [DEVICE]*
DESCRIPTION
This Bourne shell script calls the sg_start utility on each given DEVICE. The purpose is to spin up (start) each given DEVICE.
OPTIONS
Arguments to long options are mandatory for short options as well.
-h, --help
print out the usage message then exit.
-v, --verbose
increase level or verbosity.
-w, --wait
wait for the spin up (start) on each given DEVICE to complete. The default action is to do each start in immediate mode.
NOTES
If a large number of disks are spun up at the same time (i.e. without the --wait option) then the power supply may be overloaded.
EXIT STATUS
The exit status of this script is 0 when it is successful. Otherwise the exit status is that of the last sg_start utility called. See the
sg3_utils(8) man page.
AUTHORS
Written by D. Gilbert
COPYRIGHT
Copyright (C) 2009 Douglas Gilbert
This software is distributed under a FreeBSD license. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PUR-
POSE.
SEE ALSO
sg_start (sg3_utils)
sg3_utils-1.28 August 2009 SCSI_START(8)