Oracle Magazine, Jan/Feb 2018
Database Developer REST Note that any DATE or TIMESTAMP included in a result set will include the TIMEZONE for the corresponding JSON value using the Zulu time zone derived from the Oracle REST Data Services installation POSSIBLE USES REST enabled SQL provides access to remote data remote being a database where no Oracle NET Services access is provided by HTTPS Suppose you have a web application that is set up to work with one Oracle Database instance but you need to access data in another database Currently that would require one of the following A DB_ LINK from the first database to the second database The ability to open a second Oracle NET Services connection to the second database With REST enabled SQL you now have an HTTPS alternative If Oracle REST Data Services is available and configured for the second database you can just access the data via an HTTPS POST request You could also write a PL SQL routine to make the data available as a VIEW that goes across HTTPS There is also a new Type 3 JDBC driver that uses REST enabled SQL endpoints to make JDBC connections available over HTTPS You can download the Oracle REST Data Services JDBC driver from the Oracle REST Data Services download page In this blog post I show how to use this new driver with the SQLcl command line interface for Oracle Database to connect to a database via Oracle REST Data Services to ORACLE MAGAZINE JANUARY FEBRUARY 2018 113 run your queries and scripts SUMMARY Oracle REST Data Services provides a REST interface for Oracle Database It can serve custom RESTful services that run any SQL or PL SQL block and it supports
You must have JavaScript enabled to view digital editions.