MERGE INTO AIA_SYSTEMS sysreg
USING dual
on (dual.dummy is not null and sysreg.SYSTEM_CODE='AIADEMO' )
WHEN NOT MATCHED THEN INSERT (SYSTEM_ID,SYSTEM_INTERNAL_ID,SYSTEM_CODE,SYSTEM_DESC,SYSTEM_IP_ADDR,SYSTEM_URL,SYSTEM_TYPE,APPLICATION_TYPE,APPLICATION_VERSION,CONTACT_NAME,CONTACT_PHONE,CONTACT_EMAIL)
VALUES  (AIA_SYSTEMS_S.nextval,'AIA_DEMO','AIADEMO','DEMO','10.0.0.1','http://aiademo.com','Demo','SOADEMO','1.0','AIADemoContact','1234567890','demo_contact@aia.com');
