Oracle 19c JSON enhancements

View All Public Scripts Login to Run Script

Script Name Oracle 19c JSON enhancements
Visibility Unlisted - anyone with the share link can access
Description Converting table rows to JSON elements
Area SQL General / JSON
Contributor KAUSHIK NAYAK
Created Sunday March 31, 2019

Statement 1

SELECT JSON_OBJECT(*) FROM hr.employees


JSON_OBJECT(*)
{"EMPLOYEE_ID":100,"FIRST_NAME":"Steven","LAST_NAME":"King","EMAIL":"SKING","PHONE_NUMBER":"515.123.4567","HIRE_DATE":"2003-06-17T00:00:00","JOB_ID":"AD_PRES","SALARY":24000,"COMMISSION_PCT":null,"MANAGER_ID":null,"DEPARTMENT_ID":90}
{"EMPLOYEE_ID":101,"FIRST_NAME":"Neena","LAST_NAME":"Kochhar","EMAIL":"NKOCHHAR","PHONE_NUMBER":"515.123.4568","HIRE_DATE":"2005-09-21T00:00:00","JOB_ID":"AD_VP","SALARY":17000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":90}
{"EMPLOYEE_ID":102,"FIRST_NAME":"Lex","LAST_NAME":"De Haan","EMAIL":"LDEHAAN","PHONE_NUMBER":"515.123.4569","HIRE_DATE":"2001-01-13T00:00:00","JOB_ID":"AD_VP","SALARY":17000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":90}
{"EMPLOYEE_ID":103,"FIRST_NAME":"Alexander","LAST_NAME":"Hunold","EMAIL":"AHUNOLD","PHONE_NUMBER":"590.423.4567","HIRE_DATE":"2006-01-03T00:00:00","JOB_ID":"IT_PROG","SALARY":9000,"COMMISSION_PCT":null,"MANAGER_ID":102,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":104,"FIRST_NAME":"Bruce","LAST_NAME":"Ernst","EMAIL":"BERNST","PHONE_NUMBER":"590.423.4568","HIRE_DATE":"2007-05-21T00:00:00","JOB_ID":"IT_PROG","SALARY":6000,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":105,"FIRST_NAME":"David","LAST_NAME":"Austin","EMAIL":"DAUSTIN","PHONE_NUMBER":"590.423.4569","HIRE_DATE":"2005-06-25T00:00:00","JOB_ID":"IT_PROG","SALARY":4800,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":106,"FIRST_NAME":"Valli","LAST_NAME":"Pataballa","EMAIL":"VPATABAL","PHONE_NUMBER":"590.423.4560","HIRE_DATE":"2006-02-05T00:00:00","JOB_ID":"IT_PROG","SALARY":4800,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":107,"FIRST_NAME":"Diana","LAST_NAME":"Lorentz","EMAIL":"DLORENTZ","PHONE_NUMBER":"590.423.5567","HIRE_DATE":"2007-02-07T00:00:00","JOB_ID":"IT_PROG","SALARY":4200,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":108,"FIRST_NAME":"Nancy","LAST_NAME":"Greenberg","EMAIL":"NGREENBE","PHONE_NUMBER":"515.124.4569","HIRE_DATE":"2002-08-17T00:00:00","JOB_ID":"FI_MGR","SALARY":12008,"COMMISSION_PCT":null,"MANAGER_ID":101,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":109,"FIRST_NAME":"Daniel","LAST_NAME":"Faviet","EMAIL":"DFAVIET","PHONE_NUMBER":"515.124.4169","HIRE_DATE":"2002-08-16T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":9000,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":110,"FIRST_NAME":"John","LAST_NAME":"Chen","EMAIL":"JCHEN","PHONE_NUMBER":"515.124.4269","HIRE_DATE":"2005-09-28T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":8200,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":111,"FIRST_NAME":"Ismael","LAST_NAME":"Sciarra","EMAIL":"ISCIARRA","PHONE_NUMBER":"515.124.4369","HIRE_DATE":"2005-09-30T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":7700,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":112,"FIRST_NAME":"Jose Manuel","LAST_NAME":"Urman","EMAIL":"JMURMAN","PHONE_NUMBER":"515.124.4469","HIRE_DATE":"2006-03-07T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":7800,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":113,"FIRST_NAME":"Luis","LAST_NAME":"Popp","EMAIL":"LPOPP","PHONE_NUMBER":"515.124.4567","HIRE_DATE":"2007-12-07T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":6900,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":114,"FIRST_NAME":"Den","LAST_NAME":"Raphaely","EMAIL":"DRAPHEAL","PHONE_NUMBER":"515.127.4561","HIRE_DATE":"2002-12-07T00:00:00","JOB_ID":"PU_MAN","SALARY":11000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":115,"FIRST_NAME":"Alexander","LAST_NAME":"Khoo","EMAIL":"AKHOO","PHONE_NUMBER":"515.127.4562","HIRE_DATE":"2003-05-18T00:00:00","JOB_ID":"PU_CLERK","SALARY":3100,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":116,"FIRST_NAME":"Shelli","LAST_NAME":"Baida","EMAIL":"SBAIDA","PHONE_NUMBER":"515.127.4563","HIRE_DATE":"2005-12-24T00:00:00","JOB_ID":"PU_CLERK","SALARY":2900,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":117,"FIRST_NAME":"Sigal","LAST_NAME":"Tobias","EMAIL":"STOBIAS","PHONE_NUMBER":"515.127.4564","HIRE_DATE":"2005-07-24T00:00:00","JOB_ID":"PU_CLERK","SALARY":2800,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":118,"FIRST_NAME":"Guy","LAST_NAME":"Himuro","EMAIL":"GHIMURO","PHONE_NUMBER":"515.127.4565","HIRE_DATE":"2006-11-15T00:00:00","JOB_ID":"PU_CLERK","SALARY":2600,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":119,"FIRST_NAME":"Karen","LAST_NAME":"Colmenares","EMAIL":"KCOLMENA","PHONE_NUMBER":"515.127.4566","HIRE_DATE":"2007-08-10T00:00:00","JOB_ID":"PU_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":120,"FIRST_NAME":"Matthew","LAST_NAME":"Weiss","EMAIL":"MWEISS","PHONE_NUMBER":"650.123.1234","HIRE_DATE":"2004-07-18T00:00:00","JOB_ID":"ST_MAN","SALARY":8000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":121,"FIRST_NAME":"Adam","LAST_NAME":"Fripp","EMAIL":"AFRIPP","PHONE_NUMBER":"650.123.2234","HIRE_DATE":"2005-04-10T00:00:00","JOB_ID":"ST_MAN","SALARY":8200,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":122,"FIRST_NAME":"Payam","LAST_NAME":"Kaufling","EMAIL":"PKAUFLIN","PHONE_NUMBER":"650.123.3234","HIRE_DATE":"2003-05-01T00:00:00","JOB_ID":"ST_MAN","SALARY":7900,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":123,"FIRST_NAME":"Shanta","LAST_NAME":"Vollman","EMAIL":"SVOLLMAN","PHONE_NUMBER":"650.123.4234","HIRE_DATE":"2005-10-10T00:00:00","JOB_ID":"ST_MAN","SALARY":6500,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":124,"FIRST_NAME":"Kevin","LAST_NAME":"Mourgos","EMAIL":"KMOURGOS","PHONE_NUMBER":"650.123.5234","HIRE_DATE":"2007-11-16T00:00:00","JOB_ID":"ST_MAN","SALARY":5800,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":125,"FIRST_NAME":"Julia","LAST_NAME":"Nayer","EMAIL":"JNAYER","PHONE_NUMBER":"650.124.1214","HIRE_DATE":"2005-07-16T00:00:00","JOB_ID":"ST_CLERK","SALARY":3200,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":126,"FIRST_NAME":"Irene","LAST_NAME":"Mikkilineni","EMAIL":"IMIKKILI","PHONE_NUMBER":"650.124.1224","HIRE_DATE":"2006-09-28T00:00:00","JOB_ID":"ST_CLERK","SALARY":2700,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":127,"FIRST_NAME":"James","LAST_NAME":"Landry","EMAIL":"JLANDRY","PHONE_NUMBER":"650.124.1334","HIRE_DATE":"2007-01-14T00:00:00","JOB_ID":"ST_CLERK","SALARY":2400,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":128,"FIRST_NAME":"Steven","LAST_NAME":"Markle","EMAIL":"SMARKLE","PHONE_NUMBER":"650.124.1434","HIRE_DATE":"2008-03-08T00:00:00","JOB_ID":"ST_CLERK","SALARY":2200,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":129,"FIRST_NAME":"Laura","LAST_NAME":"Bissot","EMAIL":"LBISSOT","PHONE_NUMBER":"650.124.5234","HIRE_DATE":"2005-08-20T00:00:00","JOB_ID":"ST_CLERK","SALARY":3300,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":130,"FIRST_NAME":"Mozhe","LAST_NAME":"Atkinson","EMAIL":"MATKINSO","PHONE_NUMBER":"650.124.6234","HIRE_DATE":"2005-10-30T00:00:00","JOB_ID":"ST_CLERK","SALARY":2800,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":131,"FIRST_NAME":"James","LAST_NAME":"Marlow","EMAIL":"JAMRLOW","PHONE_NUMBER":"650.124.7234","HIRE_DATE":"2005-02-16T00:00:00","JOB_ID":"ST_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":132,"FIRST_NAME":"TJ","LAST_NAME":"Olson","EMAIL":"TJOLSON","PHONE_NUMBER":"650.124.8234","HIRE_DATE":"2007-04-10T00:00:00","JOB_ID":"ST_CLERK","SALARY":2100,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":133,"FIRST_NAME":"Jason","LAST_NAME":"Mallin","EMAIL":"JMALLIN","PHONE_NUMBER":"650.127.1934","HIRE_DATE":"2004-06-14T00:00:00","JOB_ID":"ST_CLERK","SALARY":3300,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":134,"FIRST_NAME":"Michael","LAST_NAME":"Rogers","EMAIL":"MROGERS","PHONE_NUMBER":"650.127.1834","HIRE_DATE":"2006-08-26T00:00:00","JOB_ID":"ST_CLERK","SALARY":2900,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":135,"FIRST_NAME":"Ki","LAST_NAME":"Gee","EMAIL":"KGEE","PHONE_NUMBER":"650.127.1734","HIRE_DATE":"2007-12-12T00:00:00","JOB_ID":"ST_CLERK","SALARY":2400,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":136,"FIRST_NAME":"Hazel","LAST_NAME":"Philtanker","EMAIL":"HPHILTAN","PHONE_NUMBER":"650.127.1634","HIRE_DATE":"2008-02-06T00:00:00","JOB_ID":"ST_CLERK","SALARY":2200,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":137,"FIRST_NAME":"Renske","LAST_NAME":"Ladwig","EMAIL":"RLADWIG","PHONE_NUMBER":"650.121.1234","HIRE_DATE":"2003-07-14T00:00:00","JOB_ID":"ST_CLERK","SALARY":3600,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":138,"FIRST_NAME":"Stephen","LAST_NAME":"Stiles","EMAIL":"SSTILES","PHONE_NUMBER":"650.121.2034","HIRE_DATE":"2005-10-26T00:00:00","JOB_ID":"ST_CLERK","SALARY":3200,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":139,"FIRST_NAME":"John","LAST_NAME":"Seo","EMAIL":"JSEO","PHONE_NUMBER":"650.121.2019","HIRE_DATE":"2006-02-12T00:00:00","JOB_ID":"ST_CLERK","SALARY":2700,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":140,"FIRST_NAME":"Joshua","LAST_NAME":"Patel","EMAIL":"JPATEL","PHONE_NUMBER":"650.121.1834","HIRE_DATE":"2006-04-06T00:00:00","JOB_ID":"ST_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":141,"FIRST_NAME":"Trenna","LAST_NAME":"Rajs","EMAIL":"TRAJS","PHONE_NUMBER":"650.121.8009","HIRE_DATE":"2003-10-17T00:00:00","JOB_ID":"ST_CLERK","SALARY":3500,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":142,"FIRST_NAME":"Curtis","LAST_NAME":"Davies","EMAIL":"CDAVIES","PHONE_NUMBER":"650.121.2994","HIRE_DATE":"2005-01-29T00:00:00","JOB_ID":"ST_CLERK","SALARY":3100,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":143,"FIRST_NAME":"Randall","LAST_NAME":"Matos","EMAIL":"RMATOS","PHONE_NUMBER":"650.121.2874","HIRE_DATE":"2006-03-15T00:00:00","JOB_ID":"ST_CLERK","SALARY":2600,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":144,"FIRST_NAME":"Peter","LAST_NAME":"Vargas","EMAIL":"PVARGAS","PHONE_NUMBER":"650.121.2004","HIRE_DATE":"2006-07-09T00:00:00","JOB_ID":"ST_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":145,"FIRST_NAME":"John","LAST_NAME":"Russell","EMAIL":"JRUSSEL","PHONE_NUMBER":"011.44.1344.429268","HIRE_DATE":"2004-10-01T00:00:00","JOB_ID":"SA_MAN","SALARY":14000,"COMMISSION_PCT":0.4,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":146,"FIRST_NAME":"Karen","LAST_NAME":"Partners","EMAIL":"KPARTNER","PHONE_NUMBER":"011.44.1344.467268","HIRE_DATE":"2005-01-05T00:00:00","JOB_ID":"SA_MAN","SALARY":13500,"COMMISSION_PCT":0.3,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":147,"FIRST_NAME":"Alberto","LAST_NAME":"Errazuriz","EMAIL":"AERRAZUR","PHONE_NUMBER":"011.44.1344.429278","HIRE_DATE":"2005-03-10T00:00:00","JOB_ID":"SA_MAN","SALARY":12000,"COMMISSION_PCT":0.3,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":148,"FIRST_NAME":"Gerald","LAST_NAME":"Cambrault","EMAIL":"GCAMBRAU","PHONE_NUMBER":"011.44.1344.619268","HIRE_DATE":"2007-10-15T00:00:00","JOB_ID":"SA_MAN","SALARY":11000,"COMMISSION_PCT":0.3,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":149,"FIRST_NAME":"Eleni","LAST_NAME":"Zlotkey","EMAIL":"EZLOTKEY","PHONE_NUMBER":"011.44.1344.429018","HIRE_DATE":"2008-01-29T00:00:00","JOB_ID":"SA_MAN","SALARY":10500,"COMMISSION_PCT":0.2,"MANAGER_ID":100,"DEPARTMENT_ID":80}

Rows 1 - 50. More rows exist.

JSON_OBJECT(*)
{"EMPLOYEE_ID":100,"FIRST_NAME":"Steven","LAST_NAME":"King","EMAIL":"SKING","PHONE_NUMBER":"515.123.4567","HIRE_DATE":"2003-06-17T00:00:00","JOB_ID":"AD_PRES","SALARY":24000,"COMMISSION_PCT":null,"MANAGER_ID":null,"DEPARTMENT_ID":90}
{"EMPLOYEE_ID":101,"FIRST_NAME":"Neena","LAST_NAME":"Kochhar","EMAIL":"NKOCHHAR","PHONE_NUMBER":"515.123.4568","HIRE_DATE":"2005-09-21T00:00:00","JOB_ID":"AD_VP","SALARY":17000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":90}
{"EMPLOYEE_ID":102,"FIRST_NAME":"Lex","LAST_NAME":"De Haan","EMAIL":"LDEHAAN","PHONE_NUMBER":"515.123.4569","HIRE_DATE":"2001-01-13T00:00:00","JOB_ID":"AD_VP","SALARY":17000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":90}
{"EMPLOYEE_ID":103,"FIRST_NAME":"Alexander","LAST_NAME":"Hunold","EMAIL":"AHUNOLD","PHONE_NUMBER":"590.423.4567","HIRE_DATE":"2006-01-03T00:00:00","JOB_ID":"IT_PROG","SALARY":9000,"COMMISSION_PCT":null,"MANAGER_ID":102,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":104,"FIRST_NAME":"Bruce","LAST_NAME":"Ernst","EMAIL":"BERNST","PHONE_NUMBER":"590.423.4568","HIRE_DATE":"2007-05-21T00:00:00","JOB_ID":"IT_PROG","SALARY":6000,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":105,"FIRST_NAME":"David","LAST_NAME":"Austin","EMAIL":"DAUSTIN","PHONE_NUMBER":"590.423.4569","HIRE_DATE":"2005-06-25T00:00:00","JOB_ID":"IT_PROG","SALARY":4800,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":106,"FIRST_NAME":"Valli","LAST_NAME":"Pataballa","EMAIL":"VPATABAL","PHONE_NUMBER":"590.423.4560","HIRE_DATE":"2006-02-05T00:00:00","JOB_ID":"IT_PROG","SALARY":4800,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":107,"FIRST_NAME":"Diana","LAST_NAME":"Lorentz","EMAIL":"DLORENTZ","PHONE_NUMBER":"590.423.5567","HIRE_DATE":"2007-02-07T00:00:00","JOB_ID":"IT_PROG","SALARY":4200,"COMMISSION_PCT":null,"MANAGER_ID":103,"DEPARTMENT_ID":60}
{"EMPLOYEE_ID":108,"FIRST_NAME":"Nancy","LAST_NAME":"Greenberg","EMAIL":"NGREENBE","PHONE_NUMBER":"515.124.4569","HIRE_DATE":"2002-08-17T00:00:00","JOB_ID":"FI_MGR","SALARY":12008,"COMMISSION_PCT":null,"MANAGER_ID":101,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":109,"FIRST_NAME":"Daniel","LAST_NAME":"Faviet","EMAIL":"DFAVIET","PHONE_NUMBER":"515.124.4169","HIRE_DATE":"2002-08-16T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":9000,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":110,"FIRST_NAME":"John","LAST_NAME":"Chen","EMAIL":"JCHEN","PHONE_NUMBER":"515.124.4269","HIRE_DATE":"2005-09-28T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":8200,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":111,"FIRST_NAME":"Ismael","LAST_NAME":"Sciarra","EMAIL":"ISCIARRA","PHONE_NUMBER":"515.124.4369","HIRE_DATE":"2005-09-30T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":7700,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":112,"FIRST_NAME":"Jose Manuel","LAST_NAME":"Urman","EMAIL":"JMURMAN","PHONE_NUMBER":"515.124.4469","HIRE_DATE":"2006-03-07T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":7800,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":113,"FIRST_NAME":"Luis","LAST_NAME":"Popp","EMAIL":"LPOPP","PHONE_NUMBER":"515.124.4567","HIRE_DATE":"2007-12-07T00:00:00","JOB_ID":"FI_ACCOUNT","SALARY":6900,"COMMISSION_PCT":null,"MANAGER_ID":108,"DEPARTMENT_ID":100}
{"EMPLOYEE_ID":114,"FIRST_NAME":"Den","LAST_NAME":"Raphaely","EMAIL":"DRAPHEAL","PHONE_NUMBER":"515.127.4561","HIRE_DATE":"2002-12-07T00:00:00","JOB_ID":"PU_MAN","SALARY":11000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":115,"FIRST_NAME":"Alexander","LAST_NAME":"Khoo","EMAIL":"AKHOO","PHONE_NUMBER":"515.127.4562","HIRE_DATE":"2003-05-18T00:00:00","JOB_ID":"PU_CLERK","SALARY":3100,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":116,"FIRST_NAME":"Shelli","LAST_NAME":"Baida","EMAIL":"SBAIDA","PHONE_NUMBER":"515.127.4563","HIRE_DATE":"2005-12-24T00:00:00","JOB_ID":"PU_CLERK","SALARY":2900,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":117,"FIRST_NAME":"Sigal","LAST_NAME":"Tobias","EMAIL":"STOBIAS","PHONE_NUMBER":"515.127.4564","HIRE_DATE":"2005-07-24T00:00:00","JOB_ID":"PU_CLERK","SALARY":2800,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":118,"FIRST_NAME":"Guy","LAST_NAME":"Himuro","EMAIL":"GHIMURO","PHONE_NUMBER":"515.127.4565","HIRE_DATE":"2006-11-15T00:00:00","JOB_ID":"PU_CLERK","SALARY":2600,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":119,"FIRST_NAME":"Karen","LAST_NAME":"Colmenares","EMAIL":"KCOLMENA","PHONE_NUMBER":"515.127.4566","HIRE_DATE":"2007-08-10T00:00:00","JOB_ID":"PU_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":114,"DEPARTMENT_ID":30}
{"EMPLOYEE_ID":120,"FIRST_NAME":"Matthew","LAST_NAME":"Weiss","EMAIL":"MWEISS","PHONE_NUMBER":"650.123.1234","HIRE_DATE":"2004-07-18T00:00:00","JOB_ID":"ST_MAN","SALARY":8000,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":121,"FIRST_NAME":"Adam","LAST_NAME":"Fripp","EMAIL":"AFRIPP","PHONE_NUMBER":"650.123.2234","HIRE_DATE":"2005-04-10T00:00:00","JOB_ID":"ST_MAN","SALARY":8200,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":122,"FIRST_NAME":"Payam","LAST_NAME":"Kaufling","EMAIL":"PKAUFLIN","PHONE_NUMBER":"650.123.3234","HIRE_DATE":"2003-05-01T00:00:00","JOB_ID":"ST_MAN","SALARY":7900,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":123,"FIRST_NAME":"Shanta","LAST_NAME":"Vollman","EMAIL":"SVOLLMAN","PHONE_NUMBER":"650.123.4234","HIRE_DATE":"2005-10-10T00:00:00","JOB_ID":"ST_MAN","SALARY":6500,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":124,"FIRST_NAME":"Kevin","LAST_NAME":"Mourgos","EMAIL":"KMOURGOS","PHONE_NUMBER":"650.123.5234","HIRE_DATE":"2007-11-16T00:00:00","JOB_ID":"ST_MAN","SALARY":5800,"COMMISSION_PCT":null,"MANAGER_ID":100,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":125,"FIRST_NAME":"Julia","LAST_NAME":"Nayer","EMAIL":"JNAYER","PHONE_NUMBER":"650.124.1214","HIRE_DATE":"2005-07-16T00:00:00","JOB_ID":"ST_CLERK","SALARY":3200,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":126,"FIRST_NAME":"Irene","LAST_NAME":"Mikkilineni","EMAIL":"IMIKKILI","PHONE_NUMBER":"650.124.1224","HIRE_DATE":"2006-09-28T00:00:00","JOB_ID":"ST_CLERK","SALARY":2700,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":127,"FIRST_NAME":"James","LAST_NAME":"Landry","EMAIL":"JLANDRY","PHONE_NUMBER":"650.124.1334","HIRE_DATE":"2007-01-14T00:00:00","JOB_ID":"ST_CLERK","SALARY":2400,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":128,"FIRST_NAME":"Steven","LAST_NAME":"Markle","EMAIL":"SMARKLE","PHONE_NUMBER":"650.124.1434","HIRE_DATE":"2008-03-08T00:00:00","JOB_ID":"ST_CLERK","SALARY":2200,"COMMISSION_PCT":null,"MANAGER_ID":120,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":129,"FIRST_NAME":"Laura","LAST_NAME":"Bissot","EMAIL":"LBISSOT","PHONE_NUMBER":"650.124.5234","HIRE_DATE":"2005-08-20T00:00:00","JOB_ID":"ST_CLERK","SALARY":3300,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":130,"FIRST_NAME":"Mozhe","LAST_NAME":"Atkinson","EMAIL":"MATKINSO","PHONE_NUMBER":"650.124.6234","HIRE_DATE":"2005-10-30T00:00:00","JOB_ID":"ST_CLERK","SALARY":2800,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":131,"FIRST_NAME":"James","LAST_NAME":"Marlow","EMAIL":"JAMRLOW","PHONE_NUMBER":"650.124.7234","HIRE_DATE":"2005-02-16T00:00:00","JOB_ID":"ST_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":132,"FIRST_NAME":"TJ","LAST_NAME":"Olson","EMAIL":"TJOLSON","PHONE_NUMBER":"650.124.8234","HIRE_DATE":"2007-04-10T00:00:00","JOB_ID":"ST_CLERK","SALARY":2100,"COMMISSION_PCT":null,"MANAGER_ID":121,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":133,"FIRST_NAME":"Jason","LAST_NAME":"Mallin","EMAIL":"JMALLIN","PHONE_NUMBER":"650.127.1934","HIRE_DATE":"2004-06-14T00:00:00","JOB_ID":"ST_CLERK","SALARY":3300,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":134,"FIRST_NAME":"Michael","LAST_NAME":"Rogers","EMAIL":"MROGERS","PHONE_NUMBER":"650.127.1834","HIRE_DATE":"2006-08-26T00:00:00","JOB_ID":"ST_CLERK","SALARY":2900,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":135,"FIRST_NAME":"Ki","LAST_NAME":"Gee","EMAIL":"KGEE","PHONE_NUMBER":"650.127.1734","HIRE_DATE":"2007-12-12T00:00:00","JOB_ID":"ST_CLERK","SALARY":2400,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":136,"FIRST_NAME":"Hazel","LAST_NAME":"Philtanker","EMAIL":"HPHILTAN","PHONE_NUMBER":"650.127.1634","HIRE_DATE":"2008-02-06T00:00:00","JOB_ID":"ST_CLERK","SALARY":2200,"COMMISSION_PCT":null,"MANAGER_ID":122,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":137,"FIRST_NAME":"Renske","LAST_NAME":"Ladwig","EMAIL":"RLADWIG","PHONE_NUMBER":"650.121.1234","HIRE_DATE":"2003-07-14T00:00:00","JOB_ID":"ST_CLERK","SALARY":3600,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":138,"FIRST_NAME":"Stephen","LAST_NAME":"Stiles","EMAIL":"SSTILES","PHONE_NUMBER":"650.121.2034","HIRE_DATE":"2005-10-26T00:00:00","JOB_ID":"ST_CLERK","SALARY":3200,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":139,"FIRST_NAME":"John","LAST_NAME":"Seo","EMAIL":"JSEO","PHONE_NUMBER":"650.121.2019","HIRE_DATE":"2006-02-12T00:00:00","JOB_ID":"ST_CLERK","SALARY":2700,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":140,"FIRST_NAME":"Joshua","LAST_NAME":"Patel","EMAIL":"JPATEL","PHONE_NUMBER":"650.121.1834","HIRE_DATE":"2006-04-06T00:00:00","JOB_ID":"ST_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":123,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":141,"FIRST_NAME":"Trenna","LAST_NAME":"Rajs","EMAIL":"TRAJS","PHONE_NUMBER":"650.121.8009","HIRE_DATE":"2003-10-17T00:00:00","JOB_ID":"ST_CLERK","SALARY":3500,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":142,"FIRST_NAME":"Curtis","LAST_NAME":"Davies","EMAIL":"CDAVIES","PHONE_NUMBER":"650.121.2994","HIRE_DATE":"2005-01-29T00:00:00","JOB_ID":"ST_CLERK","SALARY":3100,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":143,"FIRST_NAME":"Randall","LAST_NAME":"Matos","EMAIL":"RMATOS","PHONE_NUMBER":"650.121.2874","HIRE_DATE":"2006-03-15T00:00:00","JOB_ID":"ST_CLERK","SALARY":2600,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":144,"FIRST_NAME":"Peter","LAST_NAME":"Vargas","EMAIL":"PVARGAS","PHONE_NUMBER":"650.121.2004","HIRE_DATE":"2006-07-09T00:00:00","JOB_ID":"ST_CLERK","SALARY":2500,"COMMISSION_PCT":null,"MANAGER_ID":124,"DEPARTMENT_ID":50}
{"EMPLOYEE_ID":145,"FIRST_NAME":"John","LAST_NAME":"Russell","EMAIL":"JRUSSEL","PHONE_NUMBER":"011.44.1344.429268","HIRE_DATE":"2004-10-01T00:00:00","JOB_ID":"SA_MAN","SALARY":14000,"COMMISSION_PCT":0.4,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":146,"FIRST_NAME":"Karen","LAST_NAME":"Partners","EMAIL":"KPARTNER","PHONE_NUMBER":"011.44.1344.467268","HIRE_DATE":"2005-01-05T00:00:00","JOB_ID":"SA_MAN","SALARY":13500,"COMMISSION_PCT":0.3,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":147,"FIRST_NAME":"Alberto","LAST_NAME":"Errazuriz","EMAIL":"AERRAZUR","PHONE_NUMBER":"011.44.1344.429278","HIRE_DATE":"2005-03-10T00:00:00","JOB_ID":"SA_MAN","SALARY":12000,"COMMISSION_PCT":0.3,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":148,"FIRST_NAME":"Gerald","LAST_NAME":"Cambrault","EMAIL":"GCAMBRAU","PHONE_NUMBER":"011.44.1344.619268","HIRE_DATE":"2007-10-15T00:00:00","JOB_ID":"SA_MAN","SALARY":11000,"COMMISSION_PCT":0.3,"MANAGER_ID":100,"DEPARTMENT_ID":80}
{"EMPLOYEE_ID":149,"FIRST_NAME":"Eleni","LAST_NAME":"Zlotkey","EMAIL":"EZLOTKEY","PHONE_NUMBER":"011.44.1344.429018","HIRE_DATE":"2008-01-29T00:00:00","JOB_ID":"SA_MAN","SALARY":10500,"COMMISSION_PCT":0.2,"MANAGER_ID":100,"DEPARTMENT_ID":80}

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database