Yes.. U can ..

It is correlated sub query ..

if the inner sub query returns u multiple rows.. the update query actually loops thru the resultset and updates one...

rownum is not the column in the table..

its the index number .. or the row number of the result set i need to access ..

i thought it to keep it simple..

Let me give a full description..

I have two tables.. TIDLGGLS and TIDLRREP.

Among 29 columns in TIDLGGLS .. Few of concern..

TRANSLATED_TRM_160 ...