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;