Category Archives: Schema

Schema objects (tables, indexes, stored procedures,etc)

Configure the transparent gateway to access a second SQL server database.

In a previous post I explained the parameters that I used when connecting Oracle to SQL Server, now I have received another request from the developers, they need to access tables from another database in the same server. These are … Continue reading

Posted in Oracle Server, Schema | Tagged , , , , , , , , , , , , | Leave a comment

Multi table Inserts

Since Oracle 9 we can perform multitable inserts, allowing us to distribute the data from one source in one or more tables. For the first example we have a sales table (can be external or remote) like this: SELECT * … Continue reading

Posted in Oracle Server, Schema, SQL | Tagged , , , , , | 1 Comment