Oracle Magazine, March/April 2019
Database Developer PL SQL ORACLE MAGAZINE MARCH APRIL 2019 86 lastModifiedColumn name LAST_ MODIFIED versionColumn name VERSION method SHA256 creationTimeColumn name CREATED_ ON readOnly false Since I passed only a name to create_ collection all the defaults were used for the metadata which means in part that only JSON documents can be stored in the collection audit information about the collection is tracked in predefined column names and the SQL type used for documents is BLOB You can override the metadata defaults by supplying a second argument in the call to create_ collection in the form of a JSON document with the values you want to change Once a collection is created I can perform these operations Open a collection Drop a collection Get a list of all the collections in the users schema You must open a collection before you perform read or write operations The open_ collection function accepts a collection name and returns an instance of
You must have JavaScript enabled to view digital editions.