ThatJeffSmith

Tag: grid

SQL Developer Quick Tip: Reordering Columns

Do you find yourself always scrolling and scrolling and scrolling to get to the column you want to see when looking at a table or view’s data? Don’t do that! Instead, just right-click on the column headers, select ‘Columns’, and reorder as desired. Then move up the columns you want to see first… This will […]

Similar Posts by Subject Areas: , , , ,

Oracle SQL Developer and Viewing User TYPE Data

A ‘quick’ question came in this morning: “Jeff, does SQL Developer show contents of Object type columns? I’m advised not…” I wanted to say ‘Yes’ and then just run away laughing maniacally, but I thought maybe I should put together a quick example instead. So here goes. And by the way, welcome to 2013 everyone […]

Similar Posts by Subject Areas: ,

SQL Developer Quick Tip: Take the Guess Work out of NULL

There’s a lot of confusion out there about the absence of a value, also known as NULL. It can cause havoc with your queries if you don’t account for it. Some folks confuse it with a blank space in a string. At least SQL Developer can make one thing a bit easier, interpreting NULLs in […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,