ThatJeffSmith

Tag: sqldev

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

Similar Posts by Subject Areas: , , ,

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

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,