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....
CRM?
I think that's what they're called. Customer Management System? Anyway. Is there any good free ones I could give a try? I was going to script one but what I want it for was confusing me when I was
Displaying Column Names
I have a question regarding the ability to show the column names from my table/query.What I'm looking to do is to be able to have my users enter their own query via a builder (Which I haven't built
Trouble with a select list
Hello All! I was wondering if any of you guys could help me with a small problem I'm having!I'm trying to add a select list to a form on my webpage.The select list is generated from information
Asset Transfer from One plant to another within same company code
Hi,
upload photo limits
ive got a upload photo script and im just trying to make more secure currently it limits size and as you can see from my code below it limits only gif and php fileshow do i edit my code to limit all
that old Malformed Headers problem again!!!!! HELP!!!!!!
I've read the http://www.phpfreaks.com/forums/index.php/topic,37442.0.htmlI don't think my code outputs any blank lines (I can't find it anyway)I am including a functions file in my project all over
Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make it so that people that are a certain rank in my game will have their names show up bold in the users
How do I get the row number from from an sql table query
Hi allI have a table that I query and it returns a number of rows.mysql_num_rows($query) = $totalI want to have next and previous buttons, is there a way of retrieving the current row number, and can
Giving the below syntax error
Dear Experts,
Taking an HTML form and a PHP program and making it into one working file.
Hello, So I would like to display everything INSIDE a specific directory. In other words, I would like to display all file name's inside all subfolders in a specific directory. (NOT the subfolder
