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....
Displaying returned XML in another PHP page
I have an online payment form that will return XML given if a payment is successful or declines. I am using PHP cURL to do this, and it all works from the standpoint of approving or denying
Buggy registration system
Hey, I just started scripting in PHP, and I ran into a few problems.Code: <?phpinclude('config.php');if
Character Sets/Collations Stuff
Can someone please give me a check list of things I must do to setup all the charset stuff for my php/mysql social site*only for a USA town doesn't require non english characters*
script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of the page calling a script. Somehow I'm having a problem with the html page and the script both
Regular expression tips or resources
Hello! I'm having some issues implementing the appropriate regex patter to eliminate unwanted characters from a string.Here is a sample string: Code: String str = "test-hello. me please3, _dog[
How can I uploading Transactional Data from Legacy to New SAP system
Hell Gurus,
Custom Container in module pool program
Hello everyone,
php problem?
I don't think I'm stupid, but maybe I am.I am working on a sit for a friend I am try to put a link on a page and it is not working in FireFox and Safari. It works in IE but nothing else.I can get it
Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
Socket programming
Hello all,I have a PHP socket script. GPS trackers connect to this socket. IMEI verification takes place and if that is ok, the code is passed to a database. Also if the code contains alert-info, SMS
