If you weren’t paying attention over the Christmas/Winter break, it’s very possible that you haven’t heard about our new project. You can find it on the SQL Developer version 4.1 Early Adopter download page.. If you’re not into reading so much, we have 7 or 8 blogs on the subject out there, you can just watch the movie. In ten minutes I cover: what is this thing? what can it do that SQL*Plus can’t? some…
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…
In the procedure editor, the editor that’s invoked when working with PL/SQL objects, you will notice a slightly new user interface when invoking a search or a replace. Let’s cover search first. Already searched for something, and want to do it again? Check out the history. Start searching, immediately highlight all of the ‘hits.’ Remember how you can just double-click on a word to find all of the occurrences? Yeah, that still works, and it’s…
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…
When you start working with 12c, if you want to freak out (sorry, GRAB the attention of) your co-workers or folks attending your presentation, try this: Open a worksheet Write a simple query against a view, or a data dictionary view Mouse over the SELECT and wait… Should just take a second or so… So we’re now seeing the SQL ‘behind the SQL’ – an MTV spinoff I pitched that that never really took off.…
SDSQL was our first name for SQLcl. This Early Adopter preview release went to to become production ready, and used by customers for 6 years and counting! Go here to catch up on what we’ve done with SQLcl since 2014. Instead of talking about or teasing some of the cool new features of SDSQL… Wait, what is SDSQL? …I thought I would start with the basics. Like: How to install it (on Windows)How to connect…
‘Make the editor work like Sublime Text or Crimson!’ So goes the several dozen requests I get each year. Well, in version 4.1, we’ve got something I think you’ll like. It’s a bit different than column text edit modes – but it allows for the same idea, and it’s even more powerful…I think. You can set the multi-cursor ‘hot key’ in the preferences: You like? @thatjeffsmith Does it count as "lifeless geek" if I find…
Oracle SQL Developer is a graphical user interface and integrated development environment for Oracle Database. As you can imagine, a few clicks can results in an awful lot of queries being executed on your behalf. If you don’t like this fact, you can always use a command-line interface like SQL*Plus or the new sdsql. The only thing that runs there is what you explicitly type..mostly. Anyways, in version 4.1, you can now see all of…
The SQL Developer team has been steadily adding features tailored to the DBA since the version 3.0 release. This steady march continues with version 4.1. The DBA feature I want to talk about today is the Instance Viewer. To open it, you’ll need: SQL Developer 4.1 JDK 8 – this screen uses Java FX, and it’s designed with Java 8 a very high privileged account – I’m using SYS b/c I can Pst! We updated…
Go get it. Then come back here and read a couple of things. it REQUIRES Java 8 it’s not production ready – send feedback to the Forum not to Support Two new features to help you get started. SQL Formatting in the Worksheet Like the /csv/ formatting ‘hints’ you can add to your statements? Well now, you can just toggle that output mode for an entire session. You ‘unset’ the formatting by using the ‘set…
