ORA 01410 When Selecting ROWID
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA 01410 When Selecting ROWID

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    does anyone see any error in my SQL stmt?

    select rowid from dept
    where rowid in (select rowid from exceptions)
    /

    ORA-01410: invalid ROWID

    rowid in dept

    AAAA+GAAGAAAAHiAAA
    AAAA+GAAGAAAAHiAAB
    AAAA+GAAGAAAAHiAAC
    AAAA+GAAGAAAAHiAAD
    AAAA+GAAGAAAAHiAAE


    rowid in exceptions


    AAAA+GAAGAAAAHiAAB
    AAAA+GAAGAAAAHiAAE


    ?
    Share on Google+

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    I think this will work
    select rowid from dept
    where rowid in ( select row_id from exceptions )

    If we use (select rowid from exceptions), we will get the rowid's from the rows in the exceptions table, and those rowid's do not exist in dept.

    Hope this helps
    Gert
    Share on Google+

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    hmm indeed

    cheers
    Share on Google+

Posting Permissions

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


Click Here to Expand Forum to Full Width