It’s that time of year again. You’re jealous from hearing all about that fabulous conference your co-worker or Facebook buddy just got back from. You could NEVER make it a conference. Your company just doesn’t do that. If you want to go to a top-tier Oracle user group or industry conference next year, it’s time to start asking about it, today. Don’t Call It a Conference – It’s Training You say conference, your boss will…
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 try to keep my fonts ‘big’ – for folks reading my posts and for folks attending my sessions. I do lots and lots of live demo’s, and there’s a lot of code on the screen to keep track of. But I’ve generally not followed my own advice when working in a cmd shell. Oops! Fixed for next week, when I’ll be doing lots of live demo of our new favorite command line interface to…
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…
Oracle SQL*Plus has been around since 1985. It does what it does, and it does it well. SQL Developer has been around since 2006. It’s become the de facto IDE and GUI for the Database. There was an opportunity to build something new that could take the command line interface and enhance it to meet the needs of today’s database professional. So really the question that our team was faced with wasn’t ‘Why?’ it was..…
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… 1693278554686497dd4ba55_000002 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…
You may want to audit or ‘journal’ changes to your data. As you update a record, add a record, or delete a record – log that change in a different table. When doing your designs in the Data Modeler, you can ask at the time of DDL generation to have the journaling table and trigger created for one or more of your relational design tables. Step One: Hit the DDL button. For each table, you’ll…
Someone on the innerwebs asked how to show the data inside their user defined TYPE’d column in a table when querying it with SQL Developer. Here’s their code: 1693278554686497dd4ba55_000005 Run the query. Get the results. Or, in the preferences, enable this: Run the query again.
Kris (no, not THAT Kris) asks… Is there some sort of ruler that is built into this software? If not, is there some way to select a table and then specify X and Y coordinates so that I can top left align all of the diagrams that I’m creating. Currently, I am zooming in and switching between diagrams to top left align them but I feel that there has to be a better way to…
SQL Developer has a DBMS Output panel you can open and add to your desktop. You then add a connection you want to poll, and then you enable polling. It’s about 4 clicks. If you want to increase the default buffer size from 20,000 characters, then that’s a few more clicks and keystrokes. A friend of the blog (Thanks Koen!)… Tweets by @koenlostrie … suggested I share his favorite trick: using a code template to…