One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output format? Now that we have our own SQL*Plus command line interface (AKA SQLcl), the commands that are available there are…
One of the coolest bits of The Matrix, was the ability for the main characters to ‘download’ new skills or objects into their virtual reality. Like Neo could learn Kung-Fu with a simple button click. Today, I want all of you to take the (Oracle) Red Pill, and download your SQLDev knowledge pack. These are things that I see people doing ‘the hard way.’ After just a few minutes or reading (ha ha, more like…
Today’s question: How are invisible columns treated with DESC, INFO and the GUI equivalent? Super quick, an INVISIBLE column is one that the user doesn’t see. They won’t be able to access it unless they know about it. Security by obscurity? No. Tom Kyte shows a few examples of the features usefulness, especially when adding columns to a table and not breaking any SELECT * FROMs in your code. Of course, you don’t HAVE any…
We put out a HUGE update for our new SQL*Plus-style command line interface for Oracle Database. Forget how to install it, or how to connect: see the movie! Things that people really like to do in SQL Developer is pull up the object browsers to quickly see the things that a simple DESC doesn’t show. Things like comments primary keys indexes stats So SQLcl has two new commands for you. INFORMATION (INFO) Like I said,…
Can SQL Developer help me finish my SQL or code? Probably. Here’s a quick showing of what it’s capable of. Note: we enhanced this feature to be a lot more user friendly, so make sure you upgrade to the latest offering and you can do stuff like this. Need more help on the syntax? Click on the keyword in the last two examples, and you’ll be taken to Oracle DOCS syntax pages for that command.…
The Cloud! You may have heard a few things about Cloud services and Oracle over the past few years. What I’m going to talk about today is our Database Schema Service offering. It’s what it sounds like, pretty much. On a kick-butt Exadata box, you get your own schema in a database that we take care of for you. The data dictionary has been modified to make any cross-schema contamination impossible. So you just see…
It’s all in the wrist, literally. You need to know where to start and where to finish. And you need to click ‘just’ right. Watch the animation and see what I’m talking about. So a few KEY things 🙂 Start with the ‘parent’ Click on the table and ‘let go’ Now go and click on your other table Confirm your properties and hit OK You now have your key! The column in the source object…
Got a quick question from my favorite President today. So basically, Monty was asking how to get a PL/SQL Package Spec & Body to: a single file with a SET DEFINE OFF with the schema prefix in the CREATE or REPLACE Now, there’s more than one way to get one or more objects in the database out to a file. For just PL/SQL stuff, you have this on a right-click: Now, you can use the…
We’ve had another great year. Multiple product updates, 127 posts, and LOTS of questions asked and answered. Since it’s that time of year, here’s your, ‘lazy writer, popular posts’ update 🙂 Based on overall site traffic in 2014, your favorite posts from this year are: 10. Introducing the Oracle Database 12c VirtualBox OTN Image One of our most valuable resources, a free VirtualBox image providing an Oracle 12.1.0.2 Multitenant Database – plus SQL Developer, Oracle…
There are a lot of ‘Top Beers’ lists out there, but none of them are written by me. Here are the beers that I discovered, Columbus-style, and loved in 2014. Data via Untappd. In no particular order… Stone’s Coffee Milk Stout I rated this beer higher than the avg Untappd user, but I’m smarter than average. Great Lakes Blackout Stout People have been going crazy for their Christmas Ale, but I think this is better.…