03-14-2009
I hope this will help you
Hi ,
First redirect the query result to a file named "query_result.txt "
as shown below
#!/bin/ksh
sqlplus -s $USERID/$USERPWD <<EOF >query_result.txt
set heading off feedback off pagesize 0 linesize 30000 trimout on ;
select data from table_name ;
exit;
EOF
####after redirecting the output to a file fetch the value line by line as shown in below
for i in `cat query_result.txt `
do
echo $i
##do what ever u want to
delete from table_name where column_name = $i ;
##note : refer the column value as $i to get the value
done
- - - > Explaination :
here the refer the value to i ,this will fetch the records line by line
for eg : if the query output is
red
blue
green
here for the
1st iteration : i value := red
2nd iteration : i value := blue
and so on ...
I hope this wil help you ..
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am using sqlplus.
I have the stored procedure name.
How can i print the stored procedure content? (2 Replies)
Discussion started by: kamil
2 Replies
2. UNIX for Advanced & Expert Users
Hi all !
Yesterday I defined an environmental variable PATH, but today when I restarted machine, I could not see that it was stored any place.
Is there any file where I could save the settings ?
I have quite a few env.variables defined, so I need a smarter way to define.
regards
D (5 Replies)
Discussion started by: DGoubine
5 Replies
3. UNIX for Advanced & Expert Users
Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
Discussion started by: pranavagarwal
2 Replies
4. Shell Programming and Scripting
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
Discussion started by: Nareshp
5 Replies
5. Shell Programming and Scripting
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies
6. Shell Programming and Scripting
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Discussion started by: gary_w
2 Replies
7. Shell Programming and Scripting
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Discussion started by: DevendraG
2 Replies
8. Shell Programming and Scripting
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the... (3 Replies)
Discussion started by: flowervz
3 Replies
9. Shell Programming and Scripting
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Discussion started by: Sravana Kumar
5 Replies
10. Shell Programming and Scripting
Hi All,
I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).
I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Discussion started by: hkrishnan91
3 Replies
LEARN ABOUT MOJAVE
ppmdither
ppmdither(1) General Commands Manual ppmdither(1)
NAME
ppmdither - ordered dither for color images
SYNOPSIS
ppmdither [-dim power] [-red shades] [-green shades] [-blue shades] [ppmfile]
DESCRIPTION
Reads a portable pixmap as input, and applies dithering to it to reduce the number of colors used down to the specified number of shades
for each primary. The default number of shades is red=5, green=9, blue=5, for a total of 225 colors. To convert the image to a binary rgb
format suitable for color printers, use -red 2 -green 2 -blue 2.
OPTIONS
-dim power The size of the dithering matrix. The dithering matrix is a square whose dimension is a power of 2. power is that power of
2. The default is 4, for a 16 by 16 matrix.
-red shades The number of red shades to be used, including black; minimum of 2.
-green shades The number of green shades to be used, including black; minimum of 2.
-blue shades The number of blue shades to be used, including black; minimum of 2.
SEE ALSO
pnmdepth(1), ppmquant(1), ppm(5)
AUTHOR
Copyright (C) 1991 by Christos Zoulas.
14 July 1991 ppmdither(1)