This content has been marked as final. Show 5 replies
Johnbr (Oracle10G) wrote:Frankly I find that hard to believe. That CONVERT() call uses a different syntax (SQL Server?) from [url http://docs.oracle.com/cd/B28359_01/server.111/b28286/functions027.htm]the Oracle function of the same name.
I can run the sub querey in this fine,
but when I apply Select * around it, I get the Incorrect syntax near ')' error.Soon don't do that then.
Are you sure you run this query in an Oracle database?. "dbo" owner is a typical owner of other engines, like SQL server.
Anyway, inside Oracle the statement "select * from (subquery);" is valid, as well as using an alias for the subquery, "select * from (subquery) as table_alias;". But in other engines you could find only the last one valid.