comparing tables across databases sql refinement ideas required

Posted on 16th Feb 2014 07:03 pm by admin

Hi all

Via pl/sql I need to ensure that data between tables in different databases match (i.e. standby db and development db) I have made the following crude attempt.

SELECT COUNT(*) , SUM(weighted_sales), SUM(retail_value) FROM sales WHERE transaction_time_id = 5663 UNION SELECT COUNT(*), SUM(weighted_sales), SUM(retail_value) FROM sales@TOWARCHRTIBMPROD WHERE transaction_time_id = 5663

if rownumber > 1 then i know that the data for that day doesn't match.

However i don't like the sql i've used here and would like to improve upon it, any ideas? I thought perhaps using pivot to compare the data....

Your Answer:

Login to answer

Other forums

how to populate a drop down box
Hi buddies!

PROCEDURE DOWNLOAD_REPORT_FORM (report_name varchar) is begin DOWNLO

Problem with PHP code- simple contact form
I'm relativily new to PHP; I know HTML and CSS stuff but I have a problem- I have a contact form wit

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

update post issues
I am trying to create an update to a post function, while the update does occur, the page routing an

Mouseover to edit (Ajax)
hi friends, can anyone help with the code behind to get this application working, please in VB (new

need help with php get
i have a option box that gets filled with dates, but how do i get once the option value has been cli

Is there a way to override built in php functions without APD?
I am trying to use the
rename_function()
override_function()
options that are built into

Multidimensional array problems in $_POST
I'm having trouble with a three-dimensional $_POST array. It starts as a two-dimensional array on th

Javascript or not?
How many people prefer javascript/ajax sites? How many prefer the good old fashion straight php sit

Problem related to Creation of PDF File?
Hi All,
I am facing a problem related to creation pdf file. when I am creating a pdf file of do