I have got a basic question but in my database it will not work.
I have two tables. Both have the similar amount of rows. I want to add one column of the first table into the second table. Here, the values should be in the same order as before. Table1.row1 = Table2.row1; Table1.row2 = Table2.row2 ; Table1.row3 = Table2.row3....Table1.row(n) = Table2.row(n).
The issue is, there is no really connector for a join. I tried with rowid, but no selected row is presented. (permanently is the column I will add)
SElECT tab.rowid rid
nvl(permanently2, permanently) permanently,
where tab.rowid= tab1.rowid;