Copy Legacy Data with SQL

Posted At : February 1, 2008 2:00 PM | Posted By : Steve
Related Categories: SQL

In talking to a friend of mine yesterday, I realized that a great many programmers are not aware of one of the nicest features of SQL, the ability to insert the results of a query into a table. This is really handy for copying data from an old format to a newer format or if you have a need to denormalize part of a database.

[More]

Comments (2) | Print | del.icio.us | Digg It! | Linking Blogs | 5383 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)
[Add Comment]
this is a really useful technique, just be aware there is a bug in CF whch prevents this from working with the Oracle Thin JDBC driver, it works fine with the bundled data direct version.

The error message is ora-00933, Adobe have a hotfix which will be released as part of the next cumlative hofix
# Posted By zac spitzer | 2/3/08 12:14 AM
Zac,

Thanks for the info. That is good to know.
# Posted By Steve Bryant | 2/4/08 6:56 AM
[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.8.001.