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

I see questions like this on StackOverflow and related websites like, ALL THE TIME: I have some code, what’s wrong with it? Something I wish I could do, other than physically hold the person’s hand, is show them how our IDE tries to point them in the right direction of their syntax issues. But since I can’t do that, I’ll write a quick blog post and help the Google gods can help folks going forward.…

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

A relatively new feature, Proxy User Authentication allows you to connect using someone else’s credentials. Or as Oracle-Base puts it: Since Oracle 9i Release 2 it has been possible to create proxy users, allowing you to access a schema via a different username/password combination. This is done by using the GRANT CONNECT THROUGH clause on the destination user. So I’m going to alter a user, SCOTT, to allow for this. 6823983646742a7b8569b8_000001 Now, how do I…

ORDS

So you’ve installed ORDS, you’ve REST enabled a schema, and you’ve started publishing some RESTful Services. Now, how do we go about seeing what’s what? If you’re using ORDS to build ORDS REST APIs with Database Actions, AKA SQL Developer Web, simply navigate to the REST page under development. There you can find a modules page, and select your REST Module. Browsing ORDS REST Module Templates… You could search using SQL Developer Desktop’s Find DB…

SQL Developer

I’ve talked about the Cart a few times. It’s interesting to describe what the Cart is for, because it can be used or so many different things. But in general, it allows you do perform a set of operations against a collection of database objects. In this case I’m going to show you how to export several views and tables to an Excel file. And the rest of this blog post will be done using…

SQL Developer

In this 10 minute video I’ll show you: how to open a panel how to move a panel how to reset your desktop if something gets ‘borked’ how to create new desktop tab groups (for docking things) AND how to ‘float’ your doc or panel to a secondary monitor Welcome 2018! Please be sure to subscribe to my YouTube channel if you want to keep up to date on the latest video tips and tricks.…

SQL Developer

Yes, it’s that time of year again. Let’s take a quick look back at the posts (from 2017!) you read the most. SQL Developer v17.2 is now available SQL Developer v4.2 is now available Release News, What’s On Tap (where I announce our new numbering scheme) Real Time SQL Monitoring Update What is the Future of SQL Developer? Oracle Database 12cR2 is Now Available – and so is our new VirtualBox Appliance Developer Oracle REST…

Database Stuff

Mixing things up today with a quick Q&A with the guy that that generates most of the Google results to your pressing Oracle ‘how do I…?’ questions. Tim isn’t just a walking website, he’s also a great communicator. If you haven’t had a chance to see him speak at an Oracle conference, it’s probably because you don’t go to Oracle conferences – he gets around! Make sure you follow him on Twitter, subscribe to his…

SQL Developer

For 17.4, the formatter will attempt to format invalid SQL for you. If the parser runs into a problem recognizing your code, it will format it as much as it can. But that’s not all. It will ALSO go to the end of your statement, and traverse the SQL in the other direction and continue formatting as far as it can. Let’s look at an example: Before But hey, let’s format it anyway. Cause hey,…

SQL Developer

I’ve got short videos for you, 2-10 minutes. I’ve got 20 minute videos. And I’ve got monster, hour long videos. 24 in total, covering everything from how to use the PL/SQL debugger, to building REST Services, to just writing better SELECT * queries. Send me your requests, always happy to build more. I just wish I had a voice made for radio to accompany the face. Just click here to peruse the videos.