ThatJeffSmith

Category: SQL Developer

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,