Advertisement
psi_mmobile

Untitled

Oct 22nd, 2019
297
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.04 KB | None | 0 0
  1. INSERT INTO oc_poi (country, poi_id, name, oc_poi_category_id, snapping_circle, location, post_code, street, country, street_nr, lm_date, lm_name, lm_comment, oc_poi_status_id,oc_poi_hr_reg_id) VALUES ('BE',seq_oc_poi_id.NEXTVAL,'Boterberg Johan',102002,200,'LIMELETTE',1342,'rue Alfred Haulotte','33A',SYSDATE,'PSI','PERSON LOAD PROCEDURE',0,0);
  2. INSERT INTO person (lm_name,lm_comment,lm_date,person_status_id,person_id,vo_person_category_id, first_name, last_name, phone, niss, company_nr, home_poi_id, real_employer_name) VALUES ('PSI','PERSON CREATION PROCEDURE',SYSDATE, 0, seq_person_id.NEXTVAL,104376,'Johan','Boterberg','0479/33 47 92','95100936374','102',seq_oc_poi_id.currval,'BATIS MOI PLUS');
  3. INSERT INTO key_code (lm_name,lm_date,lm_comment,key_code_usage_id,key_code_id,vehicle_owner_id,person_id,key_string) VALUES ('PSI',SYSDATE,NULL,13,seq_key_code_id.NEXTVAL,101385,seq_person_id.currval,'04B7895AE35D84');
  4. INSERT INTO vo_group_person (lm_comment,person_id,vo_group_id) VALUES ('PSI person group assignment for BM',seq_person_id.currval,2742);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement