Category Archives: Schema

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

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

Posted on October 1, 2009 by

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

Posted on August 11, 2009 by

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