ThatJeffSmith

Tag: sqldev

30 Posts in 30 Days: The Reckoning

For the month of September 2014, I published a SQL Developer tip each day. September has 30 days, so that equated to 30 posts. Now normally, I post anywhere from 1-3 posts a week. Going from that to 7 days a week meant a few things: posts were going to be shorter – especially on […]

30 SQL Developer Posts in 30 Days, Day 23: Invalid Objects

A forum question today reminded me that I’ve never talked about dealing with your broken Oracle database objects in SQL Developer. So let’s take care of that in today’s post. Browsing Show me EVERYTHING that is broken Run the report. Optionally provide a schema to filter the report, the default is to show the entire […]

30 SQL Developer Tips in 30 Days, Day 18: NULLs

This post was almost NULL – I was deep in Power Point mode for Open World, and almost forgot to write today’s post! Also, another admission: I said back on Day 1 of this series, that I was planning on doing 5000 push-ups this month as well. Well, I gave up on that a few […]

30 SQL Developer Tips in 30 Days, Day 17: Using SSH Tunnels

You want to connect to the database, but: you can’t get to the server directly, or you can’t talk to the listener port If ONLY there were a way you could smuggle your database connection through another network connection that could do those things. Well there is, and it’s called an SSH tunnel. SSH talks […]