stcwp
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
STCW.INSERT_LEGAL_ENTITY
Parameters
Name
Type
Mode
Definition
PROCEDURE "INSERT_LEGAL_ENTITY" IS cursor countries is select country_id from country; BEGIN for countryId in countries LOOP BEGIN dbms_output.put_line('Inserting Governament for Country' || countryId.country_id); Insert into LEGAL_ENTITY (NAME, ENUM_LEGAL_ENTITY_ID, COUNTRY_ID, ENUM_STATUS_ID, VERSION_ID, CUSER, CDATE, MUSER, MDATE) values ('Governament', 4 , countryId.country_id, 1, 0, 'sysadmin', sysdate, 'sysadmin', sysdate); END; END LOOP; END;