oracle related

insert: 

insert into COURSE_CATEGORY (CATEGORY_ID,LABEL,UPD_DATE,USER_ID) values (:CATEGORY_ID,:LABEL,:UPD_DATE,:USER_ID)

 

clone: 

insert into course(course_id,category_id,type_id) 

select  PER_SYSTEM.COURSE_ID_SEQUENCE.NEXTVAL,c.category_id from course c  where c.course_id = '{0}'

 

query:

select resource_id,surname,first_name from IRIS_RESOURCE_EMPLOYMENT_V@agrprod where sysdate between employment_from and employment_to and (nls_LOWER(surname) LIKE '%{0}%' or nls_LOWER(first_name) LIKE '%{1}%')