| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 do DML on many tables, from many other similar tables, with minimal coding | Oracle | Advanced /
Andy Archer | 3634 since
6/22/2010 8:37:19 AM | Unrated
|
| |
This write-up with code shows how to do inserts, updates, and deletes on many tables, from many other similar tables, by using a mapping table, a REF cursor, and SQL built around PL/SQL variables. The mapping table makes for tight PL/SQL coding. |
| |
| |
| |
|
link to another instance to do inter-database DML | Oracle | Intermediate /
Andy Archer | 10253 since
3/13/2009 9:02:09 AM | Unrated
|
| |
If SQL*Net and tnsnames.ora are in order, you can create a DATABASE LINK to get to another instance to do inter-database DML on tables and views (...and that's not all). This is a write-up with examples. |
| |
| |
| |
 |
 Questions and Answers about MS Access Database Replication | Other | Beginner /
Found on the World Wide Web | 18110 since
7/13/2000 9:42:36 PM | Unrated
|
| |
Answers to common questions. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
 Toggle Table Relations | Other | Intermediate /
Lewis E. Moten III | 12347 since
5/29/2002 9:43:53 AM |
By 1 Users
|
| |
Useful for disabling constraints during database replication. When copying data to another database, use this procedure on the target database first. When finnished, run it again to enable the constraints. I used this because I was working on a database w ...(description truncated) |
| |
