I've seen several posts using select syntax similar to this: with mytab as (select * sometable) select * from mytab
as opposed to this: select * from (select * from sometable) Does the structure of the 1st query have a certain name - what keywords would I use when doing a search for the advantages/ disadvantages of the "with mytab as..." syntax? Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
