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 home apparently), so here’s a quick snapshot. As you make changes here, the REST Services, …
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 open the file after it’s created.
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 search the SQL behind my views. You’ll notice there’s an option to add wildcards around …
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, and how it works. For those of you w/o access to YouTube How do you …
Your #1 Reason for Upgrading SQL Developer to Version 4.2
Password resets. It used to be a pain – it required installing and configuring an Oracle client. But, no more! Simply get version 4.2, and you’re good to go. Here’s the video. So go get version 4.2 already.
Oracle SQL Developer v4.2 Is Now Available
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 …
4 Minute Video Tip: Navigating Database Objects
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 …
SQLcl – Setting Up the Formatter
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 …
Oracle Database 12c Release 2: Analytic Views & SQL Developer
One of the major new features in Oracle Database 12c Release 2 is Analytic Views. An analytic view is a type of view that can be used to easily extend the content of a star schema with aggregated data, measure calculations and descriptive metadata, and to simplify the SQL needed to access data. Analytic views layer a hierarchical/dimensional model over …
Updated SQLcl: 2 New Commands, Bug Fixes, and 12cR2 Oh My!
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’ …