| | |
Description | Compatibility | Level/
Author | Views/
Date
Submitted | User Rating |
| |
| |
 |
 MOVE DATABASE | SQL Server 2000, SQL Server 7.0 | Advanced /
Jose Vicente Rocamora Ballestero | 9116 since
1/16/2007 2:23:06 PM |
By 4 Users
4 Excellent Ratings
|
| |
MOVE DATABASE FILES MDF AND LDF !!!!! |
| |
| |
| |
 |
 update a table with itself, with one SQL statement | Oracle | Intermediate /
Andy Archer | 8195 since
6/15/2006 3:42:12 PM |
By 2 Users
2 Excellent Ratings
|
| |
Sometimes you may need to update a table with its own data, typically when rows contain a link to values stored in other rows. The example SQL and narrative illustrate how to do this via an Update statement with a subquery. |
| |
| |
| |
|
update one table with another table's data, with one SQL statement | Oracle | Intermediate /
Andy Archer | 82636 since
7/3/2006 12:25:52 PM |
By 8 Users
7 Excellent Ratings
|
| |
The example SQL and narrative illustrate how to update a column in one table with data from another table via an Update statement with a subquery. Merge example also included. |
| |
Please support the site by visiting our
sponsor:
|
| |
| |
|
UTL_FILE file utility - update or insert rows from Unix flat file records | Oracle | Intermediate /
Andy Archer | 20051 since
10/27/2010 8:06:11 PM |
By 3 Users
|
| |
This PL/SQL block uses UTL_FILE to read a Unix flat file, conditionally updating or inserting rows in a table from the file's records. |
| |
