July, 2018
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 […]
Install and use ORDS with Oracle Database12c
Based on Oracle® REST Data Services Release 18.2 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bits SODA for REST uses the representational state transfer (REST) architectural style to implement Simple Oracle Document Access (SODA). You can use this API to perform create, read, update, and delete (CRUD) operations on documents of any kind, and you can […]
Client-Idle System Event in Forms12c
The new System Events include the following Client-Idle (SYSTEM_CLIENT_IDLE) This event will be raised when the end-user has not performed any actions in the associated application session for the amount of time configured. The maximum idle time will be configurable using either a new applet parameter idleTimeout or using a new SET_APPLICATION_PROPERTY argument CLIENT_IDLE_TIME. Setting the […]
About Me
Senior oracle DBA/Developer | 9X OCI Certified | OCP | OCE Sql Certified Expert
