Skip to Main Content
Forums

Oracle Database Discussions

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!

invalid identifier from view

user511621Aug 14 2008 — edited Aug 14 2008
hi i have created a view using joins

now if i m doing select * from myvies
it is showing all columns and all rows

but if i do select j.JournalID from myvies
it is giving error
ERROR at line 1:
ORA-00904: "J"."JOURNALID": invalid identifier

what may be the reason.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2008
Added on Aug 14 2008
#general-database-discussions
7 comments
6,478 views