tag:blogger.com,1999:blog-21236865.post7166368970114993999..comments2008-03-21T02:43:55.997-06:00Forbrichnoreply@blogger.comBlogger3125tag:blogger.com,1999:blog-21236865.post-87312176927179101752008-03-21T02:43:00.000-06:002008-03-21T02:43:00.000-06:00Agree on public synonyms, but not on private synonyms.<BR/>But then again - private synonyms are there for the lazy or sloppy programmer, not using schema.object notations.Frankhttp://www.blogger.com/profile/07830428804236732019noreply@blogger.comtag:blogger.com,1999:blog-21236865.post-21844660967799920962008-01-23T05:50:00.000-07:002008-01-23T05:50:00.000-07:00My wish list includes a "schema_order_list" session setting to address the limitation you mention. <BR/><BR/>My point is that there are a number of situations where this will work, and people are not looking at those possibilities at all.Forbrichhttp://www.blogger.com/profile/16839603129930136268noreply@blogger.comtag:blogger.com,1999:blog-21236865.post-47481238674388040912008-01-23T02:58:00.000-07:002008-01-23T02:58:00.000-07:00This won't work in the case where you are selecting from objects in your own and another schema in same statement.Anonymousnoreply@blogger.com