06-05-2010
You're a genius. That's exactly what I needed and beautiful code as well. Thank you.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to close of multiple users in an Oracle database. Each users has records in multiple tables what I need to do is use a script that call each SQL seperately passing either CLI arguments or gathered arguments from the users during run time.
## Accept variable(s) from the command line... (1 Reply)
Discussion started by: jagannatha
1 Replies
2. Shell Programming and Scripting
U have a file
File 1
0.3 0.2 0.4 0.3 0.8 0.11 0.22
0.4 0.23 0.45 0.56 0.78 0.98
0.11 0.32 0.2 0.4 0.45 0.54
0.2 0.33 0.44 0.21 0.22 0.98
0.8 0.2 0.34 0.54 0.98 0.12
0.1 0.22 0.32 0.34 0.89 0.22
File 2
rows columns
3 1
2 3
4 2
5 ... (8 Replies)
Discussion started by: cdfd123
8 Replies
3. Shell Programming and Scripting
Hi All,
I would like to ask help on how can i achieve below output.
Inputfile:
Oct11,apa1-daily,01:25:01
Oct11,apa2-daily,01:45:23
Oct12,apa1-daily,02:30:11
Oct12,apa2-daily,01:55:01
Oct13,apa1-off,01:43:34
Oct13,apa2-off,01:22:04
Desired output:
Clients ... (3 Replies)
Discussion started by: mars101
3 Replies
4. Shell Programming and Scripting
Hi,
How to set as variable from sql output.
Query:
select aa.serial, ao.name from ann_amit aa JOIN ann_object ao on (aa.classid=ao.classid);
I got two values from aa.serial and ao.name, I wanna make two different variable for aa.serial and ao.name.
The value of aa.serial should be in... (2 Replies)
Discussion started by: KarthikPS
2 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have connected to oracle database with sqlplus -s / <<EOF
select ename, age from emp where empid=1234;
EOF
I want to save the values of ename and age in unix shell variables. Any pointers would be welcome..
Thanks in advance!!1
Cheers :):):):) (1 Reply)
Discussion started by: gonchusirsa
1 Replies
6. Shell Programming and Scripting
Hello all, I've got a script that collects data on file systems and prints out specific data about each. I've formatted headers w/ printf like so.
printf "\033
and I had the content of the varibles printed out beneath those columns like so:
printf... (5 Replies)
Discussion started by: awreneau
5 Replies
7. Shell Programming and Scripting
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
8. Shell Programming and Scripting
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
Discussion started by: FMMOLA
7 Replies
9. Shell Programming and Scripting
Hi,
I am trying to transpose rows to columns for thousands of records. The problem is there are records that have the same lines that need to be separated. the input file as below:-
ID 1A02_HUMAN
AC P01892; O19619; P06338; P10313; P30444; P30445; P30446; P30514;
AC Q29680; Q29837;... (2 Replies)
Discussion started by: redse171
2 Replies
10. 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
LDD(1) BSD General Commands Manual LDD(1)
NAME
ldd -- list dynamic object dependencies
SYNOPSIS
ldd [-a] [-v] [-f format] program ...
DESCRIPTION
The ldd utility displays all shared objects that are needed to run the given program or to load the given shared object. Contrary to nm(1),
the list includes ``indirect'' dependencies that are the result of needed shared objects which themselves depend on yet other shared objects.
Zero, one or two -f options may be given. The argument is a format string passed to rtld(1) and allows customization of ldd's output. If
one is given, it sets LD_TRACE_LOADED_OBJECTS_FMT1. If two are given, they set LD_TRACE_LOADED_OBJECTS_FMT1 and
LD_TRACE_LOADED_OBJECTS_FMT2, respectively. See rtld(1) for details, including a list of recognized conversion characters.
The -a option displays the list of all objects that are needed by each loaded object. This option does not work with a.out(5) binaries.
The -v option displays a verbose listing of the dynamic linking headers encoded in the executable. See the source code and include files for
the definitive meaning of all the fields.
EXAMPLES
The following is an example of a shell pipeline which uses the -f option. It will print a report of all ELF binaries in the current direc-
tory, which link against libc.so.6:
find . -type f | xargs -n1 file -F ' ' | grep ELF | cut -f1 -d' ' | xargs ldd -f '%A %o
' | grep libc.so.6
SEE ALSO
ld(1), nm(1), rtld(1)
HISTORY
A ldd utility first appeared in SunOS 4.0, it appeared in its current form in FreeBSD 1.1.
The -v support is based on code written by John Polstra <jdp@polstra.com>
BSD
May 15, 2008 BSD