Got a quick question from my favorite President today. So basically, Monty was asking how to get a PL/SQL Package Spec & Body to: a single file with a SET DEFINE OFF with the schema prefix in the CREATE or REPLACE Now, there’s more than one way to get one or more objects in the […]
SQL Developer 4.1: Search & Replace Enhancements
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 […]
Your Favorite Posts from 2014
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 […]
SQL Developer and a 12c Magic Trick
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 […]
SDSQL: Installing and Connecting with our new Command Line Interface to Oracle Database
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 to Oracle Database If you want to see about the ‘cool new features’, then please go read up at […]
SQL Developer 4.1: Easier Excel Imports
The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no […]
SQL Developer 4.1: Multi-Cursor Editing
‘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 […]
SQL Developer 4.1 – Log All the Queries!
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 […]
Java 8 on a Mac with SQL Developer 4.1
I ran into a few dramas getting SQL Developer 4.1 on my MacBook Air going earlier today. It boiled down to convincing SQL Developer to find and use the proper JDK on OS X Yosemite. So just in case it’s not me out there, here’s what I had to do. Unless you already have Java […]
SQL Developer 4.1 – Instance Viewer
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, which was released as an Early Adopter yesterday. Some updates…Jan 31, 2015 The DBA feature I want to talk about today is the Instance Viewer. Well, technically the window is […]
Oracle SQL Developer version 4.1 Early Adopter Now Available
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 […]
Oracle SQL Developer Data Modeler v4.1 Early Adopter is now Available
We have a new version of SQL Developer Data Modeler for you to check out – version 4.1. It’s an ‘EA’ – or early adopter. So, no official support – all feedback should be provided via the OTN Forum/Community. It requires Java 8. If you see a message about not supporting Java 8 – ignore […]
SQL Developer Formatter: Left Aligning Columns in a SELECT
Question: I can’t figure out how to make a column list align like this (underscore = space): _SELECT_column1 ______,_column2 ______,_column3 ______,_column4 ___FROM_table The closest result that the formatter produces is: _SELECT_column1, __column2, __column3, __column4 ___FROM table where all column names start at text position 3… My answer isn’t going to be perfect, but it’s going […]
Adding Columns to a Table in SQL Developer Data Modeler: Honor Column Order?
I have an employees table. Because it’s 1984, HR has decided we need to know Twitter handles, Facebook pages, and who knows what else. So let’s add it to our table. The dialog by default puts new columns at the bottom of the table. We’ll see why in just a moment. On a side note, […]
Quick Tip: Controlling how PL/SQL Errors are Shown
Remember, you only see the error messages in the log AFTER a compile. If you want to see the list of errors at any time, simply click on the ‘Errors’ page, or try compiling your program again. While we’re on this page, there’s lots and lots of cool things you can fiddle with here. For […]
Twitter
RSS
GooglePlus
Facebook