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!

ora-00904 00904.00000-"%s: invalid identifier"

508050Apr 11 2007 — edited Apr 12 2007
i first tested the the my sql with this statement and found this error that the beiw or table does not exist.


i then added the schema name before the table
and it works fine.

SELECT
*
FROM
Tschema.Ttable
where Ttable.NOTXT like '%HHHH%'


i then have my actual query and i it is not working

i am getting this error
ora-00904 00904.00000-"%s: invalid identifier"



SELECT

SFPROPERTY.PINNER,
TABCASER.CASERTYPSEEDEE,
TABCASER.CASERNUMBERING ,
SFPROPERTY.CosulDee_no ,
TABCASER.SESEADOPTDATE ,
TPCPCASER.PCPACTINGADVIDINGDATE ,
SFPROPERTY.STREETFRACNO,
Treferrence_Pl_Ar.PLAAYEDES,

TAPLICATOR.PROdesc
FROM
Schma.SFPROPERTY
LEFT JOIN Treferrence_Pl_Ar ON SFPROPERTY.PLAREEYANOMbOR = Treferrence_Pl_Ar.PLAREEYANOMbOR
INNER JOIN TEELOCATOR ON SFPROPERTY.PROP_ID = TEELOCATOR.LOOKEYEDEE
INNER JOIN TAPLICATOR ON TEELOCATOR.APPEYEDEE = TAPLICATOR.APPEYEDEE
INNER JOIN TABCASER ON TAPLICATOR.APPEYEDEE = TABCASER.APPEYEDEE
INNER JOIN TPCPCASER ON TABCASER.casereyedee = TPCPCASER.casereyedee
where TABCASER.CASERNUMBERING like '%raa%'
and SFPROPERTY.CosulDee_no = 80



HELP on my query

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 10 2007
Added on Apr 11 2007
6 comments
1,486 views