oracle 11g alias to query
-
When migrating from oracle 10g to 11g, I've a stored procedure with a syntax like:
select * from table1
union
select t,y from
(select * from table2)aliasQuery
where (select max(t)from (select t from table 3 where table3. t=aliasQuery.t)query works well with 10g but 11g returns error that aliasQuery not defined
may be this syntax no longer supported in 11g or here is some database missing configurations
Thanks
Dad
-
When migrating from oracle 10g to 11g, I've a stored procedure with a syntax like:
select * from table1
union
select t,y from
(select * from table2)aliasQuery
where (select max(t)from (select t from table 3 where table3. t=aliasQuery.t)query works well with 10g but 11g returns error that aliasQuery not defined
may be this syntax no longer supported in 11g or here is some database missing configurations
Thanks
Dad
Could you check that you wrote the query correctly. It seems incorrect.
Light moves faster than sound. That is why some people appear bright, until you hear them speak. List of common misconceptions
-
When migrating from oracle 10g to 11g, I've a stored procedure with a syntax like:
select * from table1
union
select t,y from
(select * from table2)aliasQuery
where (select max(t)from (select t from table 3 where table3. t=aliasQuery.t)query works well with 10g but 11g returns error that aliasQuery not defined
may be this syntax no longer supported in 11g or here is some database missing configurations
Thanks
Dad
Logically speaking
select ..
from ( select * from table ) aliasquery
where ...is no different from
select ..
from table aliasquery
where ...Please verify the SQL you have posted. :)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]
-
When migrating from oracle 10g to 11g, I've a stored procedure with a syntax like:
select * from table1
union
select t,y from
(select * from table2)aliasQuery
where (select max(t)from (select t from table 3 where table3. t=aliasQuery.t)query works well with 10g but 11g returns error that aliasQuery not defined
may be this syntax no longer supported in 11g or here is some database missing configurations
Thanks
Dad
The question has been answered on stackoverflow. For anyone who wants to know, the answer is No - this does not work on 11g. For more details why, go here: http://stackoverflow.com/questions/9290653/oracle-11g-alias-to-query[^]
-
The question has been answered on stackoverflow. For anyone who wants to know, the answer is No - this does not work on 11g. For more details why, go here: http://stackoverflow.com/questions/9290653/oracle-11g-alias-to-query[^]
Oracle is so great! They even fix bugs which caused such queries to be possible.
-
Oracle is so great! They even fix bugs which caused such queries to be possible.
I know, I had to think very carefully about that one. This query used to work but only because it was a bug (in other words you thought it was good, but in fact we knew it was bad), so we fixed the bug and now your query doesn't work anymore (which you may think is bad, but really it's not, because we know it's good). If I follow the argument correctly, it has something to do with ANSI standards: you should not be able to do this in ANSI-standard SQL. So in order for Oracle to be ANSI-standard, they had to stop you from doing this. I think that's the reason.