Skip to Main Content

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!

invalid identifier

kama021Feb 2 2010 — edited Feb 2 2010
SELECT DECODE (b.id, (SELECT firstnameId
FROM tablec a
WHERE a.id = 'ABC'), a.DisplayName, 'Unknown Id')
FROM tabula b


Above is a script to get the names of my customers by using decode and i get the error a.DisplayName invalid identifier.
any help using a select in a decode?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2010
Added on Feb 2 2010
4 comments
491 views