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…
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…
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…
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…
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…
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…
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…
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…
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…
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…