Table A has the following fields
Table B has the following fields
Tables A and B are joined with the field "Key". Table B has multiple records for each given value in "Key". There is a "one-to-many" relationship between A and B.
How do I accumulate values in A per the following rules?
For each record in table A
Read all records in table B that match A.Key = B.Key
If B.Status = "A" then increment A.Total1 by 1
If B.Status = "B" then increment A.Total2 by 1
If B.Status = "C" then increment A.Total3 by 1
B.Key B.Date B.Status
AAAA 01/01/2001 A
AAAA 01/02/2001 B
AAAA 01/03/2001 A
AAAA 01/04/2001 B
AAAA 01/05/2001 A
BBBB 02/01/2001 C
BBBB 02/02/2001 A
BBBB 03/01/2001 A
BBBB 04/01/2001 B
BBBB 05/01/2001 C
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…