Loading Json Docs Into Oracle Database Using Rest Apis

Developing Oracle Rest Data Services Applications The new json interface in oracle autonomous database via sql developer web and bulk loading thousands of documents with soda for rest (and ords!). You can use database apis to insert or modify json data in oracle database. you can use oracle sql function json transform or json mergepatch to update a json document. you can work directly with json data contained in file system files by creating an external table that exposes it to the database.

Developing Oracle Rest Data Services Applications I am trying to follow along with a tutorial on how to get a json object loaded into a ords table. i have this working using a standard curl with 1 record at a time but it would be great if i could feed a large file that the is then read in my rest handler via json table.

Getting Started With Oracle Rest Data Services

On Rest Apis And Oracle Database 23ai Json Native Types
Comments are closed.