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
SQL Developer

A small feature that could have a huge impact on your code – we try to make sure you know your PL/SQL might be vulnerable. SQL Injection is a very well known security risk in the database world. Nefarious people could ‘inject’ SQL into the code you’re about to execute via some some of user input you make available to them. We even talk about this in the Oracle Database Docs and provide some examples…

SQL Developer

SQL Developer’s code editors try to help you out. They’ll show you two categories of informational advisories: there is a problem with this code we think we can help you with this code These are shown by various styles of underlined text in the editor. Let’s go through the list of what’s available as of version 18.1 – to be released, soon 🙂 Actually all of these items, save 1, are available right now in…

SQL Developer

I’ve been tweaking how my SQL Developer application looks and feels for a long time. Someone saw my desktop and wanted to know how to make theirs look like mine, hence this post. I realize beauty in in the eye of the beholder, but if you behold what I behold, then here’s how to get there. I recently came across this Scheme on GitHub, and have been using it for a few months now. It’s…

ORDS

When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? 21027331966725ff532ebed_000005 REST enable that… 21027331966725ff532ebed_000006 And now let’s ‘GET’ the table. So let’s try that… Hmmm, that ‘%2’ part doesn’t look right to me. That’s actually ‘%2B’ which is a way to escape…

SQL Developer

Let’s say you have a schema you want to reverse engineer and generate some docs. Lo and behold, the developers used foreign keys! But…there are so many of them, I can’t see the forest for the trees. So how do we make this simpler? Well, our developer for the Data Modeler showed me this trick: In his words: when use synonyms is checked tables that are referred more than 9 times are removed from global…

SQL Developer

A customer ‘ambushed me’ – how dare they!?! – at the conference today, needing help getting their scripts to work. So something like this: And the way the customer wants to run scripta.sql (which calls scriptb.sql) So, where is SQL Developer going to look for scriptA? And when it gets to the @child\scriptb.sql? We can call scripts.sql using @c:\users\jdsmith\desktop\parent\scriptA.sql But, we’re going to have a problem. So, you have 2 options. First, you COULD tell…

SQL Developer

I’m in Denver today, to present one of my favorite talks, SQL Developer Tips & Tricks. Since I know most of you won’t be here today, I thought I’d share 3, super-quick tips. I get asked ‘how to do this’ type stuff, all the time. Copying Column Headers with your Data Ctrl+Shift+C Showing Line Numbers Right-click in the gutter, turn it on. It’ll remember this going forward. You’ll need to do it for the…

ORDS

You can now file bugs, sorry – submit Issues, for me on GitHub 🙂 What We’re Doing The intent is to build a nice library of How-To’s for ORDS. I’ve started with a section on PARAMETERS. ords-demo-parameters Build scripts to demonstrate working with parameters in your Oracle REST Data Services (ORDS) RESTful Services. This will demonstrate how to: Read a value in your GET handler SQL block from the request header Return a value via…

SQL Developer

What are people Googling out there, when it comes to SQL Developer? Well, Google predictive text makes that kinda easy to find out. I’m going to address these questions, but we need to address the biggest problem – without context of the actual question, I have to assume or guess what the ACTUAL question is. But, I will go for the most likely scenarios. If I got it close, but missed, feel free to dig…