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 Missing Parens Next question?
Today’s Question: How do we prevent Oracle SQL 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 all. Let’s drill into this to see what’s happening. This problem was fixed for version 4.0 of SQL Developer. See…
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 the tables in a design so I can export the column comments for everything? The CSV export does not appear…
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 here, so I’ve compiled a short list of words, terms, and phrases that might help you navigate the available materials…
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 can be cost prohibitive – lots of pages and a small audience folks go to Google for answers now However…
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 SQL Developer posts, based on traffic, of 2012: 1. How to Import from Excel to Oracle I’m not surprised this…
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 execute them without requiring a statement delimiter (usually a semicolon.) Let’s look at a quick example: 20681122736860d02dca344_000004 In some tools,…
I received this question from a customer today, and it took me more than a few minutes to remember where this preference was located in SQL Developer. This tells me that the topic is ripe for blogging 🙂 How do I go FROM: 20681122736860d02dca344_000005 TO 20681122736860d02dca344_000006 It’s all in the formatting You need to access the formatting preferences under the Tools menu. It takes a bit of navigating to get there, so bear with me:…
In yesterday’s post I talked about you could use SQL Developer’s Describe (SHIFT+F4) to open a PL/SQL Package at your cursor. If you actually try to describe the package as you see it in the above screenshot, you’ll get an error: I neglected to say in yesterday’s post that I was highlighting the package name before I hit SHIFT+F4. This works just fine, but it will work even better in our next release as we’ve…
If you’re browsing your packages using the Connections panel, you have a nice tree navigator to click around your packages and your variable, procedure, and functions. But What if you drill into your PL/SQL source from the worksheet and don’t have the Tree expanded? Let’s say you’re working on your script, something like – So I need to reacquaint myself with just what my beer package requires, so I’m going to drill into it by…
