Wednesday, May 15, 2013

Updating the New Filed as Unique Sequence having Records


Alter Table Tc_employee_mt Add Atcouid Varchar2(30);
Update Tc_employee_mt Em Set Atcouid = (Lpad(Rownum,5,0));

No comments:

Post a Comment