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....
Option box to change variable
Hello, i need help by making a script!I need to write a file with option box, so a dropdown menu with 10 or more options, and when i select one option a button to save this option to a php variable in
Inserting a variable in a link
I have this code that I want to insert for my own variable but I have no idea how. This is what I want to insert:Code: <?php echo $my_twitter_username; ?>Into this code:Code:
Standard DES encryption script?
Can anybody point me to a tutorial or a short script that shows how to encrypt some text with salt into standard DES?I know about the crypt()-function, but I'm currently writing a PHP script that
grouping within a foreach?
hello all,I currently have a list of products spit out from my db via a foreach loop. Right now I am styling these as a <li>I want to style the list so that the annual and the monthly
Why does this file not return file names that start with numbers?
This file returns a list of filenames to help populate a drop down in my form. For some reason it ignores any file names that begin with numbers, could anyone please tell my why and show me how to
What's best way to get a user's Word doc converted to simple html and images?
Hi all,I was just wondering if anybody has any experience of this.Basically, I'm building a site for a guy and he keeps throwing tonnes of content my way, all Word docs with tables, images, etc.The
Get Total From While Loop
I'm trying to get the total for each product and add them for a Grand Total to list outside the loop or only echo once I can do the addition but it will echo 5 time in the loop.How would I go about
Pls help with PHP
Pls can anyone direct me on how to create a user account for a customer. For example i want know if i need to use the "create databse" and create "user identified by ''" for each
how to load php class from another domain?
how to load php class from another domain?
Why will this program not run if the variables are not global?
Hey guys I have a kind of perplexing situation that is probably simple, but I can't seem to understand something. I have this code here that is basically a program that solves all 92 eight queens
