Question: I like SELECT *, but I don’t really want ALL the columns. Is there a better way?
Side Note: People are giving me crap on the ‘SPLAT’ – it’s perfectly acceptable! To me at least…
There’s a few better ways, and with an IDE like SQL Developer, you should expect lots of help in this area.
- drag and drop cols from the tree
- * expansion
- the Query Builder
- code insight
I have how-to’s on each of those methods. Here’s a quick video I made that shows all of them, using a SELECT * on EMPLOYEES and DEPARTMENTS.
This is the first time I tried a screen recording with QuickTime on the Mac…so no fancy editing or audio. I can do fancier if you’d like, but these are hopefully pretty simple to demonstrate, pick up.
BONUS! #5: Copy Selected Column Headers
The fans demanded I include this trick as well. So click here for another method – it involves copying column names from a grid.