I am trying to write a SQL query to compare two databases OLTP and OLAP to get the table counts eg:
we have table name W_ACT in OLAP database where count is 2500, we need to see what is the count for same table in OLTP(S_ACT).we have a long list of table counts I was wondering if some one could help me in genrating those counts all at once.
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
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…