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!

ORA-00904: invalid identifier

983149Jan 6 2013 — edited Jan 7 2013

Hi there,

I'm so sorry if this thread has been already discussed,
I'm Guntur, i'm newbie here..

Here is my SQL:

SELECT A.WHATS_NEW_ID, A.WHATS_NEW_TITLE, C.CONTENT_TITLE, A.WHATS_NEW_CREATE_DATE, A.WHATS_NEW_ACTIVE_STATUS
FROM (SELECT A.WHATS_NEW_ID, A.WHATS_NEW_TITLE, C.CONTENT_TITLE, A.WHATS_NEW_CREATE_DATE, A.WHATS_NEW_ACTIVE_STATUS, row_number()
over (ORDER BY A.WHATS_NEW_ID asc) rowsNumerator
FROM DRUPAL.TBL_WHATS_NEW A
LEFT JOIN DRUPAL.TBL_CONTENT C
ON A.CONTENT_ID = C.CONTENT_ID WHERE 1=1) qry
ORDER BY rowsNumerator

When i was executed on Oracle SQL Developer, i got this error

ORA-00904: "A"."WHATS_NEW_ACTIVE_STATUS": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 1 Column: 85

Can you help me to figure it out?
Where is my mistake?

Regards,
Guntur

Edited by: 980146 on Jan 6, 2013 5:33 AM

This post has been answered by Frank Kulash on Jan 6 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 4 2013

Added on Jan 6 2013

#sql

8 comments

15,322 views