Nurhak Kaya's Software Development Blog

update schema_name.table_name set tur_id=24 where id in(select id             from schema_name.table_name             where tur_id not in (1,24,3,4,5,7,23,21));

insert into schema_1.table_1 (   id,   kurum_id,   adi,   kayit_kullanici_id,   kayit_tarihi ) select   id,   1,   nls_upper (aciklama, 'nls_sort=xturkish'),   user_id,   user_date from schema_1.table_2;