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

reading partial code from external site
Hi,

I am trying to write a script for my website to get an article from an external website.

Loops and Classes
I am making a template system and everything seems to be going well up until I have to loop in a var

login to other site by sending post variables
hey,

here is my problem: my school gave me a mail account for school-stuff use. they mail us

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

How to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

subtract 1 from value entered in text field
Hi

How do I subtract 1 from the vaue entered into a text field?

Thanks

Reduce redundancies in switch functions?
Hello all! I somewhat new to PHP, and was wondering if anyone could give some suggestions on a swit

Count
Getting the same count everytime

Code:
$visitquery = mysql_query("SELECT COUNT(*) FR

using file_get_contents??
okay how would i create a script using file_get_contents() in php have it grab search pages 1-20 and