Skip to content

Instantly share code, notes, and snippets.

@beydogan

beydogan/insert_employee

Created November 29, 2013 00:44
Show Gist options
  • Save beydogan/7700038 to your computer and use it in GitHub Desktop.
Save beydogan/7700038 to your computer and use it in GitHub Desktop.
Download ZIP
CME4413 - Example Insert Query SQL
Raw
insert_employee
INSERT INTO EMPLOYEE VALUES
(2,
NAME_TYPE(TEMPORAL_VARCHAR('23.11.2003','09.09.2099','James Brown')),
ADDRESS_TYPE(TEMPORAL_VARCHAR('23.11.2003','09.09.9999','BUCA')),
'23.11.2003',
MANAGER_TYPE(TEMPORAL_VARCHAR('23.11.2003','09.09.9999','Mike White')),
DEPARTMENT_TYPE(TEMPORAL_VARCHAR('23.11.2003','09.09.9999','DEPT_ID05')),
SALARY_TYPE(TEMPORAL_NUMBER('23.11.2003','09.09.9999', 250000))
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment