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

SQL Developer has averaged about a single major release a year. We’ve also always had an Early Adopter or open beta where we would debut new features, and you could provide feedback. I think this worked – quite well even. But that’s over. Starting later this year, you’ll see us put our product (SQLDev, Data Modeler, SQLcl, ORDS) release updates every quarter. This allows us to keep up with the frequent release cycles we see…

SQL Developer

It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick will save you so much time, you’ll be mad I didn’t make you learn it earlier. Apply a Filter to Your SQL History Next week we’re going to work on…

SQL Developer

Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on the main File menu. First, we don’t want the main diagram in the report, that’ll give us EVERYTHING. I just want the subview diagram. So after un-checking ‘include main diagram,’…

ORDS

I had a very, very enjoyable time at the Great Lakes Oracle Conference this week in Cleveland (OHIO! – Just in case Joel is reading this.) About 400 people attended, and I think it’s become one of the best conferences in the US, esp for the bang you get for your buck. I did two talks. For the first one, they had me in the ‘big’ room – right after the day’s Keynote. The Keynote…

SQL Developer

“I do not want a line break after the and statement.” I’ve seen this come up a few times, so let’s answer that right now. 16924317566741e97ac1516_000001 Default formatting changes that to 16924317566741e97ac1516_000002 This is NOT what the person asking for help wants. To the Preferences! So let’s change that and see what happens. Or… Speaking of OR

SQL Developer

One of the new features in version 4.2 of SQL Developer is the ability to work with your ORDS Restful Services directly in the database tree. Here’s a video demo… Features via Screenshot Some of you don’t have access to YouTube at work (or at home apparently), so here’s a quick snapshot. As you make changes here, the REST Services, assuming they’re published and ORDS is actually running, are affected immediately. See my other recent…

SQL Developer

Code searching isn’t new for version 4.2. It’s not even new for version 4.1, or v4.0…but what IS new, is that some folks consider the SQL behind their VIEW objects to be ‘code.’ So, for version 4.2, you can say, search my PL/SQL source AND search the SQL behind my views. You’ll notice there’s an option to add wildcards around your search term for the ‘Code’ category – that’s useful when searching object names in…

SQL Developer

Love the command line? Hate ugly, out-of-the-box formatting of your results? You’re in luck, we have just the thing for you: Oracle SQLcl. It offers the ability to auto-pretty up your SQL results to the screen. Here’s a quick video overview of what that is, and how it works. For those of you w/o access to YouTube How do you get through your day w/o cat videos and Marvel Studios movie trailers? Anyways, here’s a…

SQL Developer

Today is the day! We have new releases of both SQL Developer and SQL Developer Data Modeler. I’ve been talking about v4.2 tweaks and enhancements for awhile now, and here’s the full list if you want to go back and review. I’d like to share a few highlights though. But first, FULL STOP. Go click that big button to the top and left. Ok, let’s continue. Formatter I’d like to thanks the entire community for…

SQL Developer

I don’t do enough video. I’ve been cheating with animated GIFs – they’re ‘nice’ because I don’t have to worry about the ‘ums’ and ‘ahs’ as I talk, or even about putting on a clean shirt. But, I have a bunch of videos I need to record for v4.2, so I thought I’d practice a bit. Here’s a short and sweet tutorial on how to go from a table to its index and back, and…