Skip to content

Instantly share code, notes, and snippets.

View kevin336's full-sized avatar

kevin336

1 follower · 1 following
  • Sungkyunkwan University
View GitHub Profile
@kevin336
kevin336 / departments.csv
Created March 31, 2019 14:13
DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
10 Administration 200 1700
20 Marketing 201 1800
30 Purchasing 114 1700
40 Human Resources 203 2400
50 Shipping 121 1500
60 IT 103 1400
70 Public Relations 204 2700
80 Sales 145 2500
90 Executive 100 1700
@kevin336
kevin336 / employees.csv
Created March 31, 2019 13:51
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
198 Donald OConnell DOCONNEL 650.507.9833 21-JUN-07 SH_CLERK 2600 - 124 50
199 Douglas Grant DGRANT 650.507.9844 13-JAN-08 SH_CLERK 2600 - 124 50
200 Jennifer Whalen JWHALEN 515.123.4444 17-SEP-03 AD_ASST 4400 - 101 10
201 Michael Hartstein MHARTSTE 515.123.5555 17-FEB-04 MK_MAN 13000 - 100 20
202 Pat Fay PFAY 603.123.6666 17-AUG-05 MK_REP 6000 - 201 20
203 Susan Mavris SMAVRIS 515.123.7777 07-JUN-02 HR_REP 6500 - 101 40
204 Hermann Baer HBAER 515.123.8888 07-JUN-02 PR_REP 10000 - 101 70
205 Shelley Higgins SHIGGINS 515.123.8080 07-JUN-02 AC_MGR 12008 - 101 110
206 William Gietz WGIETZ 515.123.8181 07-JUN-02 AC_ACCOUNT 8300 - 205 110
@kevin336
kevin336 / sqlscript.sql
Created March 31, 2019 08:50
oracle hr
REM Script: HR Objects and Data For Live SQL
REM This script will create a the HR Sample Schema objects and data in your local schema. If you want just query-only, you can instead use the HR sample schema by referencing hr.regions, etc. To drop the objects once created, you can run "Drop HR Sample Schema" -
https://livesql.oracle.com/apex/livesql/file/content_GWKN7QJBHHC8F1RJTEB47AFOY.html. Please note that this schema was initially created in 2000 and last updated March 19, 2015 so the constructs are not necessarily what we would recommend today.
-- Copyright
begin
dbms_output.put_line('Copyright (c) 2018, Oracle and/or its affiliates. All rights reserved. ');
dbms_output.put_line('Permission is hereby granted, free of charge, to any person obtaining ');
dbms_output.put_line('a copy of this software and associated documentation files (the ');
dbms_output.put_line('"Software"), to deal in the Software without restriction, including ');