I am confused get the concept of ROWID, can any one help me on this
No, we can not update the ROWID but it will chnage if row-movement has happened.
Do i need to write in PL/SQL or is it possible in SQL query?