ThatJeffSmith

Tag: data grid

SQL Developer Query & Grid Tricks

It helps to know the developers. They can tell you things that are not documented in the help or release notes. They mostly don’t hide things on purpose, mostly. They often build things into the application to aid themselves, but usually it’s for the end user’s benefit. @krisrice sent me over a few nuggets to [...]

Stupid Copy & Paste Tricks

The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive some traffic to ye olde blog (can you tell I’m in the UK this week?) So most [...]

SQL Developer Quick Hit: Zebra Pattern Data Grids

Here is a 2 second tweak that I recommend for all users of Oracle SQL Developer. Open Tools – Preferences Database – Worksheet – ‘Grid in checkerboard or Zebra pattern’ – toggle ON Now run a query in the worksheet or open a table in the browser If you’re going to be staring at data [...]

SQL Developer Quick Tip: Filtering your Data Grids

Regardless of your role or responsibility, if you work in the database, you’re going to spend a lot of time looking at data. This is usually what will push someone from the command-line to a GUI – the spreadsheet look and feel for browsing tables or query results. Since you’re going to be spending so [...]

He Ain’t Heavy, He’s My Table

Many of our Toad users need to work with really wide tables. By ‘wide’ I mean a table with many, many columns. Oracle currently supports a maximum of 1,000 columns for a table or view. If that includes you, then we can help you. Ok, maybe you don’t have a 1,000 columns, but I’m guessing [...]