Hi Friends,

I've created a view of two tables, and I included rowid because I am fetching
its uniqueness thru it. For example:
Tables:
1. LOANS_A (NAME, AMOUNT)
2. LOANS_B (NAME, AMOUNT)

CREATE VIEW LOANS AS SELECT ROWID as R1,NAME,AMOUNT FROM LOANS_A
UNION ALL SELECT ROWID as R1,NAME,AMOUNT FROM LOANS_B;

sql> SELECT R1 FROM LOANS;

R1
---

AAAAAbbbbbbdddd1ee


sql> select * from loans where r1='AAAAAbbbbbbdddd1ee';

ORA-01410: Invalid Rowid


How do I avoid this error pls....


Thanks a lot