Posts

Showing posts from March, 2014

PL/SQL Update Table Where id in Select Another Table

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));

PL/SQL Insert Into Select From Multiple Tables

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;