-
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
?
-
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
-