As much as I like the Export Comments, or hints… 54501814662259f77e534_000000 or the less intrusive SET SQLFORMAT insert… sometimes you just NEED to use the Export feature tied to a grid. Did you know you can pre-select the defaults? For example, if 9x out of 10, you send the output directly to the Worksheet, and if most of the time you work with JSON, then why not set those up? That’s a lot fewer clicks,…
Not to start a religious war, but white space in your code can cause havoc when you’re doing code compares and versioning. Some folks like tabs, others prefer to control how their code looks regardless of the editor’s tab display options. From what I can tell, SQL Developer’s code editors won’t even let you insert a tab into them – they auto-convert a tab into 2 spaces. But, if you’ve pasted tabbed code in, they’ll…
It’s already almost that time of year again. Which means I need to let you know what you can expect from our team at the world’s largest Oracle event – Oracle Open World. Sessions start on Sunday, September the 18th – but the fun with our team starts on Saturday morning. Kris Rice and I will be corralling folks to a scenic bike ride of the Bay lead by PL/SQL Product Manager extraordinaire Bryn Llewellyn.…
I say designing, because I’m going to be talking about how to do this in SQL Developer Data Modeler. And I say Part Two, because in a previous post I showed how to draw a foreign key in your relational design. This post discusses how to control the generation of the foreign key column: to generate or not if generated, how to name it Let’s start by defining the ‘foreign key column.’ If we have…
The PL/SQL team is always reminding me to talk about PL/Scope. And I got to the point where I needed to remind myself, so I added this slide in all of my PL/SQL themed talks. Yet, I have apparently forgotten to blog about it. Oops. [Docs] PL/Scope is a compiler-driven tool that collects data about identifiers in PL/SQL source code at program-unit compilation time and makes it available in static data dictionary views. The collected…
I talked about using the debugger to inspect a collection in PL/SQL using SQL Developer a few years ago. It’s been so long in fact that when Steven asked if I had a post on it, I said ‘no.’ We had gotten a question from a reader on how to look at collections while you’re debugging them. If you want to read about this topic in general, Steven’s article in Oracle Magazine is a great…
A friend of mine asked how he could generate CSV for 40 Oracle tables in Oracle SQL Developer. He could of course use Tools > Database Export to accomplish this. But, it was always the same 40 tables. And using the object picker in the wizard can get tedious, especially if it’s the same 40 tables every day/week/month/epoch. So, I told him to go shopping. The Cart, Again I’ve talked about the Cart a few…
We spend a lot of time here talking about tips, tricks, and cool things that you might have missed. These posts generally all assume you’ve been around the Oracle Database block. But many of the folks that ultimately end up here, have NEVER touched an Oracle Database before. This post is for you. You have decided to use SQL Developer, which is good. Because I can think of at least 10 reasons why SQL Developer…
Today’s post is courtesy of this question from a reader: Can the SQLDeveloper Report/Chart feature create a line chart where x contains date/time and y the values to be plotted? The answer is ‘Yes!’ I’m going to use HR.EMPLOYEES to give me my data. I start with… 54501814662259f77e534_000004 So let’s turn this into a report. SHORTCUT: In your query result-set, right-click and select ‘Save Grid as Report…’ We’re going to want a CHART report. So…
If you know how to edit your code in SQL*Plus, you already know how to do it in SQLcl. But I get asked this a lot, do you support EDIT? Do you support CHANGE? And what does SQLcl offer over those? So let’s tackle the old and then the new… C/Old/New SQL*Plus has the C[HANGE] command. C[HANGE] sepchar old [sepchar [new [sepchar]]] Changes the first occurrence of the specified text on the current line in…