View using Union Query
795014Aug 30 2011 — edited Aug 31 2011All,
How to create a view using a union query in sql developer. I tried doing but when i check the syntax I got an error
"The SQL syntax is valid, however the query is invalid or uses functionality that is not supported.
Declarative query support does not currently include UNION, INTERSECT or MINUS"
Could some one help me out
Regards