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

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

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

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

```console
[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>
```

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

* [Oracle Database 23c Free on Docker - Qiita](https://qiita.com/shakiyam/items/ca08d6a034f860f84b0b)
    * [shakiyam/Oracle-Database-23c-Free-on-Docker: A set of scripts for using Oracle Database 23c Free docker image in Oracle Container Registry](https://github.com/shakiyam/Oracle-Database-23c-Free-on-Docker)
* [Oracle Database 23c Freeの簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/3dd28eee4c2d20fe66a6)
    * [shakiyam/vagrant-oracle-database-23c-free: Vagrant + Oracle Linux 8 + Oracle Database 23c Free](https://github.com/shakiyam/vagrant-oracle-database-23c-free)
* [Oracle Database 21c on Docker - Qiita](https://qiita.com/shakiyam/items/c9e60fbf654a5cbe8567)
    * [shakiyam/Oracle-Database-21c-on-Docker: A set of scripts for using Oracle Database 21c single instance docker image in Oracle Container Registry\.](https://github.com/shakiyam/Oracle-Database-21c-on-Docker)
* [Oracle Database 21c XEの簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/f6fa0c2f27a97ebfc92e)
    * [shakiyam/vagrant-oracle-database-xe-21c: Vagrant + Oracle Linux 7 + Oracle Database 21c XE の簡易セットアップ](https://github.com/shakiyam/vagrant-oracle-database-xe-21c)
* [Oracle Database 21cの簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/580b5081038191165da2)
    * [shakiyam/vagrant-oracle-database-21c: Vagrant + Oracle Linux 7 + Oracle Database 21c (21.3) | Simple setup of a single instance database.](https://github.com/shakiyam/vagrant-oracle-database-21c)
* [Oracle Database 19cの簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/cd842a3f417c4285414a)
    * [shakiyam/vagrant-oracle-database-19c: Vagrant + Oracle Linux 7 + Oracle Database 19c (19.3) | Simple setup of a single instance database.](https://github.com/shakiyam/vagrant-oracle-database-19c)
* [Oracle Database 18c XEの簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/9bd74c08f2208346f19e)
    * [shakiyam/vagrant-oracle-database-xe-18c: Vagrant + Oracle Linux 7 + Oracle Database 18c XE の簡易セットアップ](https://github.com/shakiyam/vagrant-oracle-database-xe-18c)
* [Oracle Database 18cの簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/575148a486324b53b682)
    * [shakiyam/vagrant-oracle18: Vagrant + Oracle Linux 7 + Oracle Database 18c (18.3) | Simple setup of a single instance database.](https://github.com/shakiyam/vagrant-oracle18)
* [Oracle Database 11.2, 12.1, 12.2の簡易セットアップ - Qiita](https://qiita.com/shakiyam/items/3d2b94c118ab88fa4c79)
    * [shakiyam/vagrant-oracle12.2: Vagrant + Oracle Linux 7 + Oracle Database 12c Release 2 (12.2.0.1) | Simple setup of a single instance database](https://github.com/shakiyam/vagrant-oracle12.2)
    * [shakiyam/vagrant-oracle12.1: Vagrant + Oracle Linux 7 + Oracle Database 11g Release 2 (12.1.0.2) Enterprise Edition | Simple setup of a single instance database](https://github.com/shakiyam/vagrant-oracle12.1)
    * [shakiyam/vagrant-oracle11.2: Vagrant + Oracle Linux 7 + Oracle Database 11g Release 2 (11.2.0.4) | Simple setup of a single instance database](https://github.com/shakiyam/vagrant-oracle11.2)