I made some small, but important changes to my SQL Developer Tips & Tricks slide deck. changed up the order – the first two tricks ARE THE MOST IMPORTANT now optimized for SlideShare – hopefully easier to consume in case I’m not there to narrate/live …
Viewing Automatic SQL Tuning Advisor Tasks in Oracle SQL Developer
I got a question from our internal mailing list… I would like to know how I can view historical SQL tuning recommendations in SQL Developer 4. I don’t want to run the sql worksheet manually but view the automatic recommendations as the query has been …
PLSQL Code Editor Tricks – Preview Code Doc & Test Queries
Someone asked: @thatjeffsmith Great blog! Is there a way to display DB Doc in SQL Developer like in Java IDEs with Java doc while being in Code editor? — Sebastian Köll (@s_koell) December 1, 2016 And here’s the answer – Yes! First, let’s talk about …
7 Ways to Avoid SELECT * FROM Queries in SQL Developer
I said there were 8 ways to avoid using SELECT * FROM queries in SQL Developer – but I didn’t actually count them. So let’s do that now. @MarkusHohloch @tobias_arnhold there's about 8 ways to get columns to your query — OracleSQLDeveloper (@OracleSQLDev) November 23, …
Blacklisting Commands in Your Oracle SQLcl History
We by default don’t store certain things in your SQLcl HISTORY list – like CONNECTs. For obvious reasons, it’s best not to store certain things, either for convenience or for security. Here’s how that is controlled. SET HISTORY BLACKLIST command1, command2, …, commandN An example: …
How to Build a SubQuery with SQL Developer’s Query Builder
You want to write a query. You want to use a subquery in that query. You don’t want to type so much. What to do? Enter the Query Builder. It’s been part of your worksheet for years. Click on it. Drag a table into it. …
Your Favorite Oracle SQL Developer Trick, Animated.
I had the privilege of spending a few days in Argentina and Brazil last week presenting on all things SQL Developer. It turns out, they enjoy the very same tricks that folks everywhere else do – especially the split editors and multiple tab groups. Here’s …
Version 4.2 Work Continues – Keep up the Feedback and Comments!
So version v4.2 has been out for Early Adopter testing and feedback since September. We’re still doing work on those new features and improvments, and will also be adding additional features and tweaks in a 2nd Early Adopter update, stay tuned. We’re of course also …
Data Modeler: Foreign Key Create New Column vs Use Existing
When using the data modeler, we assume when you add a foreign key, you haven’t already created the ID column. So we create that for you. Here’s what that looks like. I draw the relationship. I don’t want that. I want it to use USER.USER_ID …
Filter All The Things
I often spend a lot of time on the ‘cool’ and ‘advanced’ tips and tricks when doing talks for SQL Developer. Today, I’m co-presenting with Helen , and she chose to spotlight a bunch of stuff around filtering. Follow @HelenJSanders I love the topic, but …