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
?