Oracle SQL: Using subquery factoring in an INSERT statement This is an off-site link.  Please review our Terms of Service for additional information.

(Lucas Jellema) I use subquery factoring a lot, to make my SQL queries easier to write. This basically means that most of my queries these days start with WITH rather than SELECT. (this feature was introduced in the 9i release of the Oracle Database).

Read this article...

comments powered by Disqus