Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    1

    Unanswered: Toad Rowid Problem

    here is my query:

    select rowid from XXX.dtecre,XXX.contexte,XXX.pc,YYY.LOGIN,ZZZ.NOM,Z ZZ.PRENOM from XXX, YYY,ZZZ
    where ZZZ.numuser=XXX.numuser and numpat=40000 and rowid= :XXX.dtecre,XXX.contexte,XXX.pc,ZZZ.LOGIN,XXX.NOM, XXX.PRENOM
    and XXX.numpers=ZZZ.numuser
    order by DTECRE

    there is a problem with the ROWID Command
    I Have the error message "ORA-00933: SQL command not properly ended"

    Can You help me please

  2. #2
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    The line rowid= :XXX.dtecre,XXX.contexte,XXX.pc,ZZZ.LOGIN,XXX.NOM, XXX.PRENOM doesnt make any sense and you do know that rowid is an oracle generated column

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •