Auto REST with ORDS: An Overview and What’s Next?

In the current issue of Oracle Magazine, you can read all about how to get started with the Auto REST feature of Oracle REST Data Services…or in other words, how to automatically make Tables and Views available via REST APIs. A table or view is very easy to consider as a resource in the REST model. What ORDS does... [Read More]

SQLcl – Setting Up the Formatter

Just because you’re in a command line interface doesn’t mean you’re stuck with ugly code! Wait, if it’s my code, you’re stuck with ugly code. But if it’s YOUR code, then you’re not stuck with poorly formatted code. You can of course use the FORMAT command to format what’s... [Read More]

Oracle Database 12c Release 2: Analytic Views & SQL Developer

One of the major new features in Oracle Database 12c Release 2 is Analytic Views. An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and to simplify the SQL needed to access data. Analytic views layer a... [Read More]

Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!

You have a new version of SQLcl to download this morning. Lots and lots of bug fixes – again, thanks everyone in the community for providing feedback so we can make continuous improvements. A few things of note: Two New Commands They do pretty much what you’d expect. FIND and WHICH – hopefully will... [Read More]

Parameters and Binds for your RESTful Services: RESULTSETs

Yesterday I talked about how to grab the output returned from your stored procedure when executing via Oracle REST Data Services. The example was: INSERT a new record into a table. Return the new employee ID and the total number of employees in the table. So we just needed 2 parameters for our handler to catch the two... [Read More]

Parameters and Binds for your RESTful Services

I have a very simple, and not very elegant stored procedure. CREATE OR REPLACE PROCEDURE ADD_EMP ( P_EMP_NAME IN SIMPLE_EMP.name%TYPE, P_EMP_SALARY IN SIMPLE_EMP.SALARY%TYPE, P_OUT_ID OUT SIMPLE_EMP.id%TYPE, P_OUT_TOTAL OUT INTEGER ) AS BEGIN INSERT INTO SIMPLE_EMP (name,... [Read More]

Oracle Database 12c Release 2 is Now Available…and so is our New VirtualBox Appliance!

Want to get started on learning everything there is to know about the latest version of our Database? Don’t want to really have to install or create anything? Well, you’re in luck. Just go download our image. The image is up and running, complete with sample data for you to play with. In a few minutes,... [Read More]