Missed out on KScope17 this week, or were there, but missed out on my talks? Have no fear – you can now catch up on the 3 Oracle SQL Developer features that you should be using, but probably aren’t. I tried my best not to …
Release News – What’s On Tap
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 …
Mandatory SQLDev Tip: Filter Your History
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 …
How Do I Get My Charts Out of a Report?
Someone asked, I have this cool report, how do I get the chart out of it? For now I’ve been taking screenshots. So let’s look at how you can get your Report out to HTML (and a PNG.) When I say HTML, I mean you …
Generating a Data Dictionary Report and Diagram for a SubView
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 …
And…? Formatting in Version 4.2
“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. SELECT 1 FROM dual WHERE 1=2 AND 2=3 AND 3=4 Default formatting changes that to SELECT 1 FROM dual WHERE …
Developing Oracle REST Data Services with SQL Developer 4.2
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 …
How to Save a Package and Package Body to a .SQL File
Got this question: Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper — Felipe Pereira (@FelipeR_Pereira) April 27, 2017 Answer: YES. Then set your file type. Now to confirm I’m really getting what I want. SQL Developer will automatically …
Searching Source Code & Your Views in 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 …
Video Overview of SET SQLFORMAT ANSICONSOLE
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, …