ThatJeffSmith

Tag: sql

We Want You..to Eat, Breathe, and Live SQL

Our developer advocate team, led by Steven Feuerstein of PL/SQL fame, is looking for someone to help spread the good word – about SQL. You can read about the job here, but I thought I would throw in my two or even 3 cents on the matter. I have been evangelizing or advocating or helping […]

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 […]

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 […]

Oracle Database 12c SQL Translation Framework: Fixing Bad SQL

One of the new Database 12c features is the SQL Translation Framework. Developed primarily to help customer migrate their 3rd party applications and databases to the Oracle stack, it also offers application DBAs an opportunity to substitute poorly performing SQL with their own custom SQL – without changing the application itself! Do I have your […]

Oracle SQL Developer: Configuring Object DDL Scripts

One of the more popular features in SQL Developer is the ability to generate the CREATE DDL script for any object. If you open an object editor, the SQL page shows this script. Now, what many of you don’t realize is that the way this code can be generated is configurable. The requests I am […]

How to Compare PL/SQL and SQL in Oracle SQL Developer

This question has come up a few times recently. One person asked how to compare 2 SQL statements at Open World. In fact, they claimed if I could show them how to do it, it would make the trip to San Francisco worth every penny. Don’t be surprised they left extremely satisfied Then just yesterday, […]

Grants Now Included in SQL Developer SQL Pages

Quickly copying objects to a new environment is easy in SQL Developer. You simply go to the object in the tree and access the SQL page. However a few of our users were complaining that we weren’t including the object privileges that had been GRANTed in the SQL script. So after re-creating the object in […]

‘Forcing’ Line Breaks in Oracle SQL Developer

Oracle SQL Developer is at its heart, an Interactive Development Environment (IDE.) So it comes with the territory that developers should expect to be able to write good code quickly. One of the many code ‘helpers’ that a good IDE will provide is a Formatter. Formatters, or code beautifiers as they’re also known, take poorly […]

Don’t Try This at Home – Database Edition

Just because you can do something, doesn’t necessarily mean that you should. Case in point, database object names. Yes, you can call a table in Oracle pretty much anything you want, including ‘TABLE.’ Using quotes allows you to do some pretty silly things like use reserved words, mixed case names, and worse. On a call […]

SQL Developer Quick Tip – Leading Comma Formatting

Some folks find this hard to read If your computed column code or column names are very long, they’ll often trail off the edge of the viewable screen. If you’re missing a comma somewhere, you’re bound to run up against an ORA-. You want to know right away WHERE you’re missing the separator. I covered […]

Click AND Type your Queries with the Integrated Query Builder

I was perusing the SQL Developer Feature Requests Exchange and was not surprised to see this – a request to have the Query Builder disabled. My favorite (and most predictable) comment among the voters for this request is something along the lines of ‘feature totally useless for us professionals’ Let’s explore that for a second. […]

Watching Paint Dry or V$SQLTEXT_WITH_NEWLINES

How much time to do you spend debugging database application problems? Probably more time than you want. How much of that time is spent capturing the SQL that is being submitted by your application to the database? I’m going to guess that it’s a significant amount. Asssuming you have access to production (or a test […]

Related Posts Plugin for WordPress, Blogger...