OracleDatabase12C
Use SQL Developer Command-Line (SQLcl) to run SQL-scripts
SQL Developer Command Line SQLcl 18.2 Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. You can, both execute in interactive or batch mode, sql and Pl/SQL. It supports all previously written SQL*Plus scripts. You can download the SQLcl 18.2 here First, we locate hr_main.sql script on our disk, […]
Store and manipulate json data in Oracle database 12.2.0.1.0
Store and manipulate json data in Oracle database 12.2.0.1.0 For the purpose of the post, I use the json-document generated in the previous post, see https://linecode-notes.com/2018/07/16/install-and-use-ords-with-oracle-database12c/ First, we create a table to store our json-document. JSON_TABLE creates a relational view of JSON data. You can query the result returned by the function as a virtual relational […]
About Me
Senior oracle DBA/Developer | 9X OCI Certified | OCP | OCE Sql Certified Expert
