31 lines
1.5 KiB
SQL
31 lines
1.5 KiB
SQL
spool /mnpapp/log/script/RU_176.log
|
|
|
|
alter table dbcgo_lov
|
|
add (order_by number);
|
|
|
|
update dbcgo_lov set order_by=1 where lov_name='OT' and name='LO';
|
|
update dbcgo_lov set order_by=2 where lov_name='OT' and name='NO';
|
|
update dbcgo_lov set order_by=3 where lov_name='OT' and name='NE';
|
|
update dbcgo_lov set order_by=4 where lov_name='OT' and name='CN';
|
|
update dbcgo_lov set order_by=5 where lov_name='OT' and name='C';
|
|
update dbcgo_lov set order_by=6 where lov_name='OT' and name='S1';
|
|
update dbcgo_lov set order_by=7 where lov_name='OT' and name='S2';
|
|
update dbcgo_lov set order_by=8 where lov_name='OT' and name='NN';
|
|
|
|
update dbcgo_lov set order_by=1 where lov_name='OT_REC' and name='LO';
|
|
update dbcgo_lov set order_by=2 where lov_name='OT_REC' and name='NO';
|
|
update dbcgo_lov set order_by=3 where lov_name='OT_REC' and name='NE';
|
|
update dbcgo_lov set order_by=4 where lov_name='OT_REC' and name='CN';
|
|
update dbcgo_lov set order_by=5 where lov_name='OT_REC' and name='C';
|
|
update dbcgo_lov set order_by=6 where lov_name='OT_REC' and name='S1';
|
|
update dbcgo_lov set order_by=7 where lov_name='OT_REC' and name='S2';
|
|
update dbcgo_lov set order_by=8 where lov_name='OT_REC' and name='VEDG';
|
|
update dbcgo_lov set order_by=9 where lov_name='OT_REC' and name='N8VS';
|
|
update dbcgo_lov set order_by=10 where lov_name='OT_REC' and name='CCBU';
|
|
update dbcgo_lov set order_by=11 where lov_name='OT_REC' and name='CCCO';
|
|
update dbcgo_lov set order_by=12 where lov_name='OT_REC' and name='CUP';
|
|
update dbcgo_lov set order_by=13 where lov_name='OT_REC' and name='TS';
|
|
|
|
commit;
|
|
|
|
spool off |