10-14-2008
Get data from 3 differrnt oracle DB & then compare data
Hi All,
I have a requirement to write a shell script for the following...
we have 3 different database.... lets say A, B, C
From these 3 DBs, i need to get data.. all have 3 different table...a,b, c
A.a => Emp_code, count(*)
B.b => emp_code, count(*)
C.c => emp_code, copunt(*)
Once get this information, i need to compare these 3 tables using common emp_code
For example, for emp_code=100....
A.a.count(*) = B.b.count(*) & B.b.count(*) > C.c.count(*) If it is true then no action else write to log_file.
Can you please help me how to do it... all are Oracle DB
7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
i willbe very much grateful to u if u help me out..
if i simply connect pbx machine to printer by serial port RS232 then we find this view:
But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies
2. Shell Programming and Scripting
Hey, dunno if the title really explains this well; basically my problem is (and this is on a router which is why the flash issue)...
I have some data I want to store (it's really irelevant, i'm just counting the lines per file, basically a simple counter).
I could store this data in flash but... (0 Replies)
Discussion started by: pepsi_max2k
0 Replies
3. UNIX for Dummies Questions & Answers
Dear unix gurus,
I have a data file with header information about a subject and also 3 columns of n rows of data on various items he owns. The data file looks something like this:
adam peter
blah blah blah
blah blah blah
car
01 30 200
02 31 400
03 57 121
.. .. ..
.. .. ..
n y... (8 Replies)
Discussion started by: tintin72
8 Replies
4. Shell Programming and Scripting
My input file:
data_5 Ali 422 2.00E-45 102/253 140/253 24
data_3 Abu 202 60.00E-45 12/23 140/23 28
data_1 Ahmad 256 7.00E-45 120/235 140/235 22
data_4 Aman 365 8.00E-45 15/65 140/65 20
data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies
5. Shell Programming and Scripting
cat file1.txt
field1 "user1":
field2:"data-cde"
field3:"data-pqr"
field4:"data-mno"
field1 "user1":
field2:"data-dcb"
field3:"data-mxz"
field4:"data-zul"
field1 "user2":
field2:"data-cqz"
field3:"data-xoq"
field4:"data-pos"
Now i need to have the date like below.
i have just... (7 Replies)
Discussion started by: ckaramsetty
7 Replies
6. Shell Programming and Scripting
Hello experts,
Please help me in achieving this in an easier way possible. I have 2 csv files with following data:
File1
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:35:47,JOB_5330
08/23/2012 12:36:09,JOB_5340
08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350
08/23/2012... (5 Replies)
Discussion started by: asnandhakumar
5 Replies
7. UNIX for Dummies Questions & Answers
Hi guys, looking for some help with a way to compare data in two files but with some conditions.
example,
File 1 consists of
site1,10.1.1.1
site2,20.2.2.2
site3,30.3.3.3
File 2 contains
site1,l0.1.1.1
site2,50.1.1.1
site3,30.3.3.3
site4,40.1.1.1
I want to be able to match the... (1 Reply)
Discussion started by: mutley2202
1 Replies
stack(n) Tcl Data Structures stack(n)
NAME
stack - Create and manipulate stack objects
SYNOPSIS
package require Tcl 8.2
package require struct ?1.2.1?
stackName option ?arg arg ...?
stackName clear
stackName destroy
stackName peek ?count?
stackName pop ?count?
stackName push item ?item ...?
stackName size
DESCRIPTION
The ::struct::stack command creates a new stack object with an associated global Tcl command whose name is stackName. This command may be
used to invoke various operations on the stack. It has the following general form:
stackName option ?arg arg ...?
Option and the args determine the exact behavior of the command. The following commands are possible for stack objects:
stackName clear
Remove all items from the stack.
stackName destroy
Destroy the stack, including its storage space and associated command.
stackName peek ?count?
Return the top count items of the stack, without removing them from the stack. If count is not specified, it defaults to 1. If
count is 1, the result is a simple string; otherwise, it is a list. If specified, count must be greater than or equal to 1. If
there are no items on the stack, this command will return count empty strings.
stackName pop ?count?
Return the top count items of the stack, and remove them from the stack. If count is not specified, it defaults to 1. If count is
1, the result is a simple string; otherwise, it is a list. If specified, count must be greater than or equal to 1. If there are no
items on the stack, this command will return count empty strings.
stackName push item ?item ...?
Push the item or items specified onto the stack. If more than one item is given, they will be pushed in the order they are listed.
stackName size
Return the number of items on the stack.
KEYWORDS
queue, matrix, tree, graph
struct 1.2.1 stack(n)