Love vi? Prefer emacs? Want the power of the 80′s added to Oracle SQL Developer? You can do that via our External Tools feature. And you can even have SQL Developer throw over your open file into vi, edit it, save it, and refresh the buffer in the worksheet to reflect the file changes. Here’s [...]
General
How to Copy Only Column Headers from Query Results in Oracle SQL Developer
Short and sweet post today – let’s say you’ve written a SELECT *, and your query results have some column headers you want to copy out. Yes, you could copy out the result set WITH the column headers, but maybe you JUST want the column names themselves. Note you need to select which column headers [...]
Configuring Display of Model Relationships in Oracle SQL Developer Data Modeler
The end goal for many users of Oracle SQL Developer Data Modeler is a a nicely formatted, easy to read diagram. Diagrams are composed of two primary components: Tables or Entities Relationships Today’s post is all about how to manage the display of the relationships. How can I move the lines around? You might not [...]
Managing Storage Properties for Multiple Tables in Oracle SQL Developer Data Modeler
There were more than a few questions I didn’t get a chance to answer in last week’s webcast with @ODTUG, ‘Data Modeling 101 with Oracle SQL Developer.’ If you’re a member of ODTUG, then you can watch or download the webcast. If you’re NOT a member, you can still sign up to attend KSCOPE13 in [...]
How to Hide Schema Notation from Tables in Oracle SQL Developer Data Modeler
Today’s question: Argh ! How can I remove the schema name from the relational diagram for a table in Sql Data Modeler ? Let’s take a quick look at the user’s source of frustration. I’ve previously reverse-engineered several Oracle schemas into a relational model in Oracle SQL Developer. HR and two other HR-Cloned users containing [...]
Oracle SQL Developer Quick Hit: Paren Matching
Today’s Question: Does anyone know of an editor (or program) that will match beginning and ending parentheses in sql and highlight an ending paren that is missing? It just so happens that I do know of such an amazing editor or program I’ll let the pictures do the talking for me this afternoon: Matched Parens [...]
Preserving Privilege Grants Whilst Editing Views in Oracle SQL Developer
Today’s Question: How do we prevent Oracle SSQL Developer from dropping the grants/privileges when modifying a view. While using SQL Developer we modified a view and once saved it removed all of the user access previously set up for the view. This did not previously take place when using… Ugh. That doesn’t sound good at [...]
A SQL Developer Primer: Open a New Worksheet
The Worksheet in Oracle SQL Developer is your primary interface for writing and running your SQL and PL/SQL code. As you can imagine, I’ve already written quite a bit about how the worksheet ‘works’. Today I want to spend just a few moments explaining the two different buttons for launching a new worksheet. With a [...]
Exporting Table Column Comments to Excel using Oracle SQL Developer Data Modeler
I love it when I get product and technology questions from our users. More often than not, it leads to me citing a blog post on the subject, or even better, inspires new writing material. And that’s the case for today’s post: Is there an easy way to fake the search tool into getting all [...]
A SQL Developer Primer: Glossary of Terms
Technical folks have a tendency to assume everyone is familiar with the words, abbreviations, acronyms, etc. that they causally throw out in conversations and the written word. This is one of many things that can intimidate or dissuade the new folks from being able to participate in the conversation. I don’t want that to happen [...]
Oracle SQL Developer and Viewing User TYPE Data
A ‘quick’ question came in this morning: “Jeff, does SQL Developer show contents of Object type columns? I’m advised not…” I wanted to say ‘Yes’ and then just run away laughing maniacally, but I thought maybe I should put together a quick example instead. So here goes. And by the way, welcome to 2013 everyone [...]
Oracle SQL Developer Book?
I’m frequently asked about books for SQL Developer. There are a few out there, with the most obvious example being from former Product Manager Sue Harper. I love books, and I’m a voracious reader. But books pose a few problems in the techie space: they are out of date the day they are printed they [...]
Top 10 Most Popular Oracle SQL Developer Posts of 2012
Yes, another ‘Top 10′ list is here! Yes, it’s lazy. But, I’m all about lazy, and just because it’s lazy and overdone, doesn’t mean it has no value. If you’re new here or if you have a hard time catching up with all of your favorite bloggers and news outlets, here are my most popular [...]
The Problem Should Define the Process, Not the Tool
I’m stepping down from my SQL Developer pulpit today and standing up on my philosophical soap box. I’m frequently asked to help folks transition from one set of database tools over to Oracle SQL Developer, which I’m MORE than happy to do. But, I’m not looking to simply change the way people interact with Oracle [...]
SQL Developer: Why Do You Require Semicolons When Executing SQL in the Worksheet?
There are many database tools out there that support Oracle database. Oracle SQL Developer just happens to be the one that is produced and shipped by the same folks that bring you the database product. Several other 3rd party tools out there allow you to have a collection of SQL statements in their editor and [...]
Twitter
RSS
GooglePlus
Facebook