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

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 allows you to interact with them via GET, PUT, POST, and DELETE – without writing…

SQL Developer

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 the formatter default settings! Have no fear. Load up the GUI. Yes, THAT GUI. Set…

Oracle SQLcl new commands, find and which SQL Developer

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’ LOGIN.SQL What’s a ‘local’ LOGIN.SQL? It’s a LOGIN.SQL file that we find in your current…

oracle rest data services module parameter resultset ORDS

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 integers returned, easy-peasy. But, what if we were going to return the entire record? So let’s write…

SQL Developer

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 my PL/SQL. That is, it didn’t until 12cR2. Starting with Oracle Database 12c Release 2…

Database Stuff

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 SQL Developer. Plus, you’ll get lots of Hands On Labs! Step by step instructions allow…

SQL Developer

Want to export a ton of tables, but only get SOME of the records? Want to apply a GLOBAL filter across the tables to only get the records you want? Tools > Database Export. I’m going to export data, NOT DDL. I’m going to write it to a single JSON file. I’m going to grab data from a couple of tables. I ONLY want records from those tables where the CUSTOMER ID is in a…

info command oracle sql developer SQL Developer

Many of you might not know that most of what you can do in SQcl, can also be done in SQL Developer version 4.2. In fact, it’s the same code that handles running statements/scripts in SQLcl as it is in SQL Developer’s SQL Worksheet. Assuming of course, that you use THIS button. There’s one large exception to this. TODAY: we don’t allow you to use the SCRIPT command, yet. And one small exception: you can…

SQL Developer

Reviewing my timeline, I came across this gem from Franc. I hate seeing SQL with keywords in uppercase and identifiers in lowercase. identifiers are case sensitive. Not keywords.— Franck Pachot (@FranckPachot) February 7, 2017 Franck isn’t alone – a lot of people hate it when their code doesn’t look the way they want it to. Many folks know about our formatter, and how to use it to get their IDENTIFIERS UPPER-CASED. But did you know…

SQL Developer

A friend, let’s call her ‘Helen’ for the sake of this post, texted me the other day, wondering why she had all these dozens/hundreds (?) of files in her Windows home directory. She was confused. Where did they come from? Were they safe to delete? I asked her what they were called, and the filename sounded VERY MUCH like what she would have named her SQL Developer connection for a particular database. Now, it might…