More than 1 year has passed since last update.

Oracle Database 19cの簡易セットアップ

Last updated at 2023-07-13Posted at 2019-04-26

Oracle Database 19cがリリースされました。
手元のPC上のVirtualBoxでサクッとセットアップする手順を自動化したので公開します。

shakiyam/vagrant-oracle-database-19c: Vagrant + Oracle Linux 7 + Oracle Database 19c (19.3) シングル環境の簡易セットアップ

Oracle Database 19cではJSONの扱いがより簡単になりました。例えば、SELECT JSON_OBJECT(*) FROM hr.employees WHERE rownum <= 3;というクエリーで、表employeesの3行のJSON表現を得ることができます。

[oracle@localhost ~]$ sqlplus system/oracle@localhost/pdb1

SQL*Plus: Release 19.0.0.0.0 - Production on Fri Apr 26 03:48:18 2019
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.

Last Successful login time: Fri Apr 26 2019 03:47:26 +00:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> SELECT JSON_OBJECT(*) FROM hr.employees WHERE rownum <= 3;

JSON_OBJECT(*)
--------------------------------------------------------------------------------
{"EMPLOYEE_ID":100,"FIRST_NAME":"Steven","LAST_NAME":"King","EMAIL":"SKING","PHO
NE_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","P
HONE_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}

JSON_OBJECT(*)
--------------------------------------------------------------------------------


SQL>

それ以外のバージョンの手順も下記にて公開しています。

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up