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

thatjeffsmith ORDS 0 Comments

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 is …

SQLcl – Setting Up the Formatter

thatjeffsmith SQL Developer 0 Comments

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 in a file or in the SQLcl buffer. I don’t like …

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

thatjeffsmith SQL Developer 11 Comments

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. You’ll also notice something new on startup/connects if you’re using a ‘local’ …

Parameters and Binds for your RESTful Services

thatjeffsmith ORDS 0 Comments

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, SALARY) VALUES (P_EMP_NAME, P_EMP_SALARY) RETURN id INTO P_OUT_ID;   SELECT COUNT(id) INTO P_OUT_TOTAL FROM SIMPLE_EMP;   EXCEPTION WHEN OTHERS THEN HTP.print(SQLERRM); END; Sidebar: Like, …

PL/Scope in Oracle Database 12c Release 2 and Oracle SQL Developer

thatjeffsmith SQL Developer 6 Comments

PL/Scope is one of my favorite features. It answers SO many questions. Where am I declaring this, where am I calling that, when am I referencing something? And, I can get this information automatically, without hitting the big, fat SOURCE data dictionary views. I’ve talked about this previously… …BUT, PL/SCope didn’t help me with tracking the SQL I used in …

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

thatjeffsmith Database Stuff 1 Comment

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. In a few minutes, you’ll be up and running with Database 12c Release 2. And APEX 5.1. And ORDS 3.0.9. And of course …