Hi,
Can anyone tell me how to print the column name anong with the value from the table in shell script e.g
#!/bin/ksh
var=`sqlplus scott/tiger << -e
set heading off feedback off
select * from emp;
quit;
e`
echo $var
My output should be;
... (5 Replies)
hi,
Can some one help me how to retrieve column values row by row
My requirement is like below :
I have a text file having comma seperated values of these records .
OName OType SrcDB Sschema targetdb TSchema Load Dataype processY/N
aa Table a e i m Y db2 y
aa index b c d e N sql N
... (4 Replies)
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Hi, Guys. Please help me to find solution to this problem using shell scripting.
I have an INPUT file with 4 columns separated by tab. Each block of records is separated by -----
-----
Sample1 5402 6680 Pattern01
Sample2 2216 2368 Pattern02... (6 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
I have file that looks like this,
DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151
DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797
DIP-19588N|refseq:NP_731165 ... (2 Replies)
I want to bring values in the second column into single line for uniq value in the first column.
My input
jvm01, Web 2.0 Feature Pack Library
jvm01, IBM WebSphere JAX-RS
jvm01, Custom01 Shared Library
jvm02, Web 2.0 Feature Pack Library
jvm02, IBM WebSphere JAX-RS
jvm03, Web 2.0 Feature... (10 Replies)
Discussion started by: kchinnam
10 Replies
LEARN ABOUT DEBIAN
pclock
PCLOCK(1) General Commands Manual PCLOCK(1)NAME
pclock - pixmap clock
SYNOPSIS
pclock [options]
DESCRIPTION
This manual page documents briefly the pclock command. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
pclock is a program that places a small analog clock program on the desktop of X. It was designed to run under the WindowMaker window man-
ager. It uses any 64x64 pixmap as a background.
OPTIONS
The programs follow the usual GNU command line syntax, with long options starting with two dashes (`-') and short optoins starting with one
dash. A summary of options is included below.
-B PIXMAP, --background=PIXMAP
Use the given pixmap as the clock background (size must be 64x64).
-H COLOR, --hands-color=COLOR
Draw the hands (hour, minute and second) in the specified color.
-S COLOR, --second-hand-color
Draw the second hand in the specified color
-h, --help
Show summary of options.
--hour-hand-length=INT
Draw the hour hand with the specified length of INT.
--minute-hand-length=INT
Draw the minute hand with the specified length of INT.
--second-hand-length=INT
Draw the second hand with the specified length of INT.
--second-hand-width=INT
Draw the minute hand with the specified width of INT.
-s, --second-hand
Don't display the second hand.
-v, --version
Show version of program.
-w, --withdrawn
Don't start up in a withdrawn (iconic) state.
AUTHOR
This manual page was written by Darren Benham <gecko@debian.org>, for the Debian GNU/Linux system (but may be used by others). The soft-
ware is copyrighted (c) 1998 by and released under the GPL v2.
Author: Alexander Kourakos <Alexander@Kourakos.com>
Web: http://www.kourakos.com/~awk/pclock/
PCLOCK(1)