balbanyab
asked on
INCLUDE ROWID VALUE IN THE TABLE
I created a table as
Create table table1 (col1 varchar2(10),
col2 number(5),
table1_rowid rowid),
primary key is col1
I Want when I insert new row then the column table1_rowid must contains value of rowid of the same row. then how I can do that, what action and steps I have to do, I know that I have to create a trigger after insert of each row, but what is the plsql procedure I have to do. Please can you provide me with cleared solution?
Tanks in advance
ORAHOT
Create table table1 (col1 varchar2(10),
col2 number(5),
table1_rowid rowid),
primary key is col1
I Want when I insert new row then the column table1_rowid must contains value of rowid of the same row. then how I can do that, what action and steps I have to do, I know that I have to create a trigger after insert of each row, but what is the plsql procedure I have to do. Please can you provide me with cleared solution?
Tanks in advance
ORAHOT
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Once you have found the record with whichever query you have, then tha actual rowid is current. Rowids can change as well, when you do partition switches, and other physical file maintenance.
Not sure what happenes when you rebuild the indexes, the rowid might also change then, as they are not physically held ont eh database.