Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Creating nested views in PL/SQL

698464May 8 2009 — edited May 15 2009
Is it possivble to create nested views in oracle? I have a view called vOriginalView and I am trying to create another view called vTestView which basically all it does is (SELECT * FROM VOriginalView).

SQL developer is giving me the following message and does not allow me to create the view.

"The SQL syntax is valid, however the query is invalid or uses functionality that is not supported."
"Cannot find relation VOriginalView".


Thank you
Marios
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 12 2009
Added on May 8 2009
4 comments
915 views