I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
ORDS

You have stored or generated some bits that you want to stream down to your web client from your Oracle Database. And while ORDS likes to format things as JSON for you, you really don’t want that to happen in this case. Here, I have ALREADY handled the output processing via my SQL, I just wants ORDS to pass it down DIRECTLY to the client. When you define your HTTP (GET) handler as a ‘Media…

SQL Developer

Got this question today and realized I didn’t really have a specific blog post that shows how to do that, so here we go! First things first, we need to go back and talk about the logical vs relational vs physical models again in SQL Developer Data Modeler. Logical Model – entities and attributes. We’re describing our data and how things are related. There are no tables yet. ERDs come from here. Relational Model -…