|
|
Sponsored Content
Top Forums
UNIX for Advanced & Expert Users
passing value to a variable in a SQL
Post 302134383 by jim mcnamara on Thursday 30th of August 2007 02:55:22 PM
08-30-2007
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi my UNIX Friends,
Im calling some SQL scripts through Unix Shell scripting.
How do I export the value of PL/SQL variable value into a Unix shell script variable?
Also could any one inform me about the 'search' and 'cut' utility of PL/SQL
(like 'grep' and 'cut' in Shell scripting).
... (10 Replies)
Discussion started by: ganapati
10 Replies
2. Shell Programming and Scripting
Hi,
How can I pass an argument to a pl/sql block through perl/unix shell scripting. (2 Replies)
Discussion started by: er_ashu
2 Replies
3. Shell Programming and Scripting
I have this piece code in a shl, I need to pass paramaters to a PL\SQL
PRECEDURE like $fseqno and faidy I know that the $fseqno works correctly but I am not sure aboyt the faidy
can I code it like that faidy ='0910' ?
Thank you
for i in 3526*.dat
do
# Capture just the file... (1 Reply)
Discussion started by: rechever
1 Replies
4. Shell Programming and Scripting
Hi Gurus,
i have one requirement in unix script, i have a file called abc.txt in that few lines are there with the empid, i need to read each line and pass to .sql script.
ex:
abc.txt
2345
2346
1243
1234
i need to pass these arguments to .sql script rom unix
ex:
select * from... (1 Reply)
Discussion started by: Devendar
1 Replies
5. UNIX for Advanced & Expert Users
Hi Everyone,
Can anyone help me how do i call hash variable in to sql query in perl. Please see the script below
i have defined two Hash %lc and %tab as below
$lc{'REFF'}='V_RES_CLASS';
$lc{'CALE'}='V_CAP_CLASS';
$lc{'XRPD'}='V_XFMR_CLASS';
$tab{'V_RES_CLASS'}='V_MFR_SERS';... (6 Replies)
Discussion started by: jam_prasanna
6 Replies
6. Shell Programming and Scripting
Hi Guys,
I am trying to pass a string variable from Unix shell script to sqlplus as a parameter.
I have tried using single quotes with the variable name but it does not work. Please help me with it.
I am using BASH.
My code:
Your help is much appreciated.
Thanks,
shil (2 Replies)
Discussion started by: infintenumbers
2 Replies
7. Shell Programming and Scripting
How to pass variable to sql file.
Im tryin in two ways,
Method 1:
my.sql
select * from table where col1 = '$1' and col2 = 'text';
Method 1execute: dbaccess database my.sql $var
Method2:
select * from table col1 in (`cat inputfile`) and col2 = 'text';
method... (2 Replies)
Discussion started by: Roozo
2 Replies
8. Shell Programming and Scripting
Hi Friend,
I have one file in which some number are mentioned and number of lines are vary every time
And i need to pass that number to my sql command from script.
Suppose i have file acc.txt
45456546456
45464564565
67854353454
67657612132
Number of records are vary every time.... (20 Replies)
Discussion started by: pallvi_mahajan
20 Replies
9. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
10. Shell Programming and Scripting
Hi all,
I have a a file which contains an oracle query. If this file is pushed into a shell script such as the below, it of course works fine.
#!/usr/bin/sh
su - oracle -c 'sqlplus -s / as sysdba <<EOF
@/home/cron/ORA/sql/T-ORA006-OracleSessions.sql
exit;
EOF
.
What i am after... (2 Replies)
Discussion started by: nms
2 Replies
LEARN ABOUT DEBIAN
avahi-resolve
avahi-resolve(1) General Commands Manual avahi-resolve(1) NAME
avahi-resolve - Resolve one or more mDNS/DNS host name(s) to IP address(es) (and vice versa) using the Avahi daemon SYNOPSIS
avahi-resolve --name host-name ... avahi-resolve-host-name host-name ... avahi-resolve --address address ... avahi-resolve-address address ... DESCRIPTION
Resolve one or more mDNS/DNS host name(s) to IP address(es) (and vice versa) using the Avahi daemon. OPTIONS
When passing -n, specify one or more fully qualified mDNS/DNS host name(s) (e.g. "foo.local") to resolve into IP addresses on the command line. When passing -a, specify one or more IP address to resolve into host names. avahi-resolve-host-name is equivalent to avahi-resolve --name. avahi-resolve-address is equivalent to avahi-resolve --address. -n | --name Translate one or more fully qualified host names into addresses. -a | --address Translate one or more addresses into fully qualified host names. -v | --verbose Enable verbose mode. -6 When resolving a host name, look for IPv6 addresses exclusively. -4 When resolving a host name, look for IPv4 addresses exclusively. -h | --help Show help. -V | --version Show version information. AUTHORS
The Avahi Developers <avahi (at) lists (dot) freedesktop (dot) org>; Avahi is available from http://avahi.org/ SEE ALSO
avahi-publish-address(1), avahi-daemon(8) COMMENTS
This man page was written using xml2man(1) by Oliver Kurth. Manuals User avahi-resolve(1)