|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Passing a parameter from a shell script to sqlplus
Post 302844000 by Mahomed on Friday 16th of August 2013 04:45:47 AM
08-16-2013
Hi Durden_Tyler,
Thank you kindly for your reply.
Please excuse my dumb question...
where must this go? in the sql script?
Regards
Mahomed
cat -n per12.sql
1 begin
2 dbms_output.put_line ('You entered PID = ' || '&1');
3 dbms_output.put_line ('You entered PEE = ' || '&2');
4 end;
5 /
6
Thank you kindly for your reply.
Please excuse my dumb question...
where must this go? in the sql script?
Regards
Mahomed
cat -n per12.sql
1 begin
2 dbms_output.put_line ('You entered PID = ' || '&1');
3 dbms_output.put_line ('You entered PEE = ' || '&2');
4 end;
5 /
6
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I want to pass parameters from a shell script to a sql script and use the parameter in the sql query ..and then I want to spool a particular select query on to my unix box... for 4 different locations by writing only one sql script
Right now no file is generated on the unix box...it is a... (2 Replies)
Discussion started by: phani
2 Replies
2. Shell Programming and Scripting
hi,
I am using a shell script from where i will be conecting to sqlplus..
i am having a problem in passing a variable to sqlplus query..
i will be assigning the variable in the unix environment..whenever i am trying to pass a variable having the contents greater than 2500 characters, i am... (3 Replies)
Discussion started by: kripssmart
3 Replies
3. Shell Programming and Scripting
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Discussion started by: sanora600
1 Replies
4. Shell Programming and Scripting
Hi All,
I have a 2 files. File1 i am generating using an ETL tool, which is a comman seperated delimited file which contains country code & load date.
everytime, this country code will be updated from a table. It might be AB or BA & ld_date will be for which date we need to load the file.
... (7 Replies)
Discussion started by: Amit.Sagpariya
7 Replies
5. AIX
I would like to run a compress script on files in certain directories.
My compress_script.sh is just basically
compress file*
In order for me to use this I have to copy it into each directory and run it.
How can I state the directory on the command line with the compress script so it... (2 Replies)
Discussion started by: NycUnxer
2 Replies
6. SCO
OS SCO Open Server 6.0 MP4
I am trying to change the value of a enviornment variable thru a script and want to pass a parameter on the commande line, If I hard code the value inside the script the script changes the enviornment variable
. mytest
where my test is
MYVAR=$1
export MYVAR... (6 Replies)
Discussion started by: atish0
6 Replies
7. Shell Programming and Scripting
Hi,
I have one shell script which use two parameter however one of its parameter have space in between.
eg.
a.sh 20110114 b c d
here b c d is one parameter
I used 'b c d' but its not giving correct result.
Also i tried b\c\d but this one also didnt work.
Any help would be... (5 Replies)
Discussion started by: diehard
5 Replies
8. UNIX for Dummies Questions & Answers
hi All,
i m trying to pass a user choice paramter from unix to sqlplus connect command
here i want the user to enter the username and password he wants to connect in sql plus through read in unix and then automatically connect to that instance.
sqlplus -s $1/$2
where $ 1 and $2 will b... (2 Replies)
Discussion started by: Jcpratap
2 Replies
9. Shell Programming and Scripting
Hello All,
I am interested in finding out a way to pass parameters that are entered at the prompt from HP unix and passed to SQLPlus code with a Shell Script. Is this possible?
Thanks (4 Replies)
Discussion started by: compprog11
4 Replies
10. Shell Programming and Scripting
Hello All,
I am trying below
+++++++++
#/bin/bash
set -x
Host=$1
Port=$2
User=$3
Pass=$4
Warning=$5
Critical=$6
SCRIPT_LOC=/opt/agent/
Parameters="'""hostname=$Host&""port=$Port&""username=$User&""password=$Pass&""jvm=UsedMemory,$Warning,$Critical""'"
echo $Parameters... (10 Replies)
Discussion started by: sundari127
10 Replies
LEARN ABOUT DEBIAN
isql
isql(1) UnixODBC Reference isql(1) NAME
isql - utility to submit SQL queries to a data source. iusql - Unicode version of isql. SYNOPSIS
isql DSN [UID [PWD]] [options] DESCRIPTION
isql can be used to submit SQL to a data source and to format/output results. It can be used in batch or interactive mode. OPTIONS
DSN Name of the data source you want to connect to. UID Your login to connect the DSN. PWD Your password needed to login to the DSN. -b Batch mode. It will not do any prompting. -dx Delimit columns with x. -x0xXX Delimit columns with XX, where XX is in hex. For example -x0x09 will use a tab. -w Wrap results in an HTML table -c Print column names on first row. This options only has effect in combination with the -d option. -mn Limit column display width to n -v Verbose output. --version This prints the version. EXAMPLES
cat My.sql | isql WebDB MyID MyPWD -w Each line in My.sql must contain exactly 1 SQL command except for the last line which must be blank. AUTHOR
This manual page was written by Kurt Roeckx <kurt@roeckx.be> for the Debian package of unixODBC. UnixODBC Dec 2004 isql(1)