Create Or Replace Function Get_Addr
(P_Line Number, P_Addr Varchar2)
Return Varchar2 Is
Type Addr_Typ Is Table Of Varchar2(1000);
V_Addr Addr_Typ;
V_Tmp Varchar2(1000);
I Pls_Integer;
J Pls_Integer;
K Pls_Integer;
L Pls_Integer;
Begin
  V_Tmp:=Rtrim(P_Addr)||Chr(10);
  For I In 1..P_Line Loop
    V_Addr(I):='';
  End Loop;
  I:=0;
  L:=Length(V_Tmp);
  While (L > 0)
  Loop
    K:=Instr(V_Tmp,Chr(10));
    If K = 0 Then
      Exit;
    End If;
    J:= K-1;
    If J > 0 Then
      I:=I+1;
      V_Addr(I):= Substr(V_Tmp,1,J);
      V_Tmp:=Rtrim(Substr(V_Tmp||' ',K+1));
    End If;
    L:=Length(V_Tmp);
  End Loop;
  Return V_Addr(P_Line);
End;
/

UPDATE MyAddrTab
     SET Address2=Get_Addr(2,Address)
         , Address3=Get_Addr(3,Address);
COMMIT;
UPDATE MyAddrTab
     SET Address=Get_Addr(1,Address);
COMMIT;