ThatJeffSmith

Category: Database Stuff

30 SQL Developer Tips in 30 Days, Day 11: Tree Trimming

Many of you are not DBAs or developers. You spend most of your time browsing tables, running queries, and answering questions that help make your business ‘go.’ The SQL Developer Connection Tree shows a whole lot of stuff that you might not ever use. So turn it off. Tools – Preferences – Database – Navigation […]

30 SQL Developer Tips in 30 Days, Day 6: Try the Schema Browser

I’m at a friend’s house, sans laptop, so today’s post will be short and sweet. Also, no pictures! In your connection tree, on an active (connected) connection, right-click and select the Schema Browser. If you hop around users/schemas frequently in a database, you may enjoy the drop-down control for toggling.

30 SQL Developer Tips in 30 Days, Day 5: Connectivity Issues

The most frequently posted question when it comes to Oracle Database, HAS to be around connectivity. If you’re just starting out working with the database, not being able to connect to said database has to be a very frustrating experience. And for some reason our error messages tend to confuse folks even further. And not […]

30 SQL Developer Tips in 30 Days, Day 4: Statement Execution

A few quick things to remember: Try to always use statement delimiters Even before I go to execute this ‘statement’, SQL Devleoper is telling me I have a problem. The grammar check is failing. Notice those red squiggle lines? They actually mean something. So, add a semi-colon, or do this: Know the difference between executing […]

30 SQL Developer Tips in 30 Days, Day 3: Syntax Highlighting

Someone asked the other day, ‘how can I make tables show up in blue?’ In the preferences, find the ‘PLSQL Identifier’ entry in the PL/SQL Syntax Colors entry, and set it to whatever color you’d like. Another example… Grammar Squiggles, They’re Hard to See Sometimes This time, look for the ‘Disconnected Join Graph’ entry. One […]

30 SQL Developer Tips in 30 Days, Day 2: NLS Parameters

This might be the most important set of preferences in Oracle SQL Developer. The settings on this page directly impact how your queries run and the results they return. One of the most curious and fun to debug questions I get from users is something along the lines of… Why does my query return X […]

Oracle SQL Developer: Code on Demand

I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… …but I’m lazy. So this: The Setup Open your preferences and go to the SQL […]