ThatJeffSmith

Category: SQL Developer

30 SQL Developer Tips in 30 Days, Day 21: Executing Multiple Statements to Multiple Data Grids

Impatient? Want to run a query, then run another – getting both sets of results to a data grid? Don’t mind leaving cursors open? These are serious questions. But if you’re feeling adventurous, feel free to try this out. Select multiple queries Execute Or, if you prefer to watch the movie… Did you notice that […]

Similar Posts by Subject Areas: , , ,

30 SQL Developer Tips in 30 Days, Day 20: See, Click, Goto Error Messages

This question comes up very frequently: Why can’t I see my compilation errors when I’m working with PL/SQL? Because you are either: using the wrong editor, or not asking to see the errors SQL Developer is the PL/SQL IDE for the database. So we obviously need to have those ‘fancy’ IDE features like a debugger, […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 19: Quick and Clean Table Copies

Quick and clean, what’s that? Consider the following: CREATE TABLE new_table AS SELECT * FROM old_table WHERE 1=2; I call that ‘quick and dirty,’ and I imagine you have used this technique many, many times. But, I wish it would have grabbed column comments, indexes, maybe even the partitions. Partitioning a table after the fact […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 13: Executing Very Large Scripts

What’s a very large script? That’s a subjective question, and the answer will depend somewhat on the hardware specs of your machine. I got this question yesterday: @thatjeffsmith is there a limit to the number of lines I can paste into the code editor in SQL developer? — louise mcscootash (@metalouise) September 12, 2014 I […]

Similar Posts by Subject Areas: , , ,

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

Similar Posts by Subject Areas: , , ,

30 SQL Developer Tips in 30 Days, Day 10: Compare Stuff Side By Side

We try to make comparing things easy to do. When you’re troubleshooting, you frequently need to know why A isn’t quite like B. So let’s look at a few scenarios. Execution Plans or Autotrace Runs Run a plan or autotrace. Pin it. Run another. Right-click on one, and compare with the other. Voila. Looking at […]

Similar Posts by Subject Areas: , , , , , ,

30 SQL Developer Tips in 30 Days, Day 9: You Only Need to Run One Copy at a Time

You know that thing where you’re sitting shotgun, or the horror – in the backseat – and you notice the driver doing something that drives you crazy? For me it was my best friend in college who refused to acknowledge that his car had 4 gears. He’d never shift out of 3rd gear. Somehow I’m […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 8: Use the Cart to Build Deployment Scripts

Let’s say you have some objects you need to quickly create somewhere else. And you want to it such that it can be scripted/scheduled. I am using the Cart right now to build out a demo environment for folks that want to show off some SQL Developer features. For instance, I’m building a ‘shopping list’ […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 7: The Array Fetch Size Preference

I have found a lot of users like to tweak this preference without really understanding what it does: Standard JDBC also enables you to specify the number of rows fetched with each database round-trip for a query, and this number is referred to as the fetch size. [DOCS] So if you execute a query and […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,