SQL Developer 4.2 Oracle Execution Plans – More Columns Available

thatjeffsmith SQL Developer 19 Comments

Someone on the Forums (yes, we read and respond!) noticed they couldn’t add Bytes or Time to their plan displays in Oracle SQL Developer. So we just made all of the columns available now, even if a few them might not make sense, i.e. TEMP_SPACE, OTHER. Preferences – Database – Autotrace/Explain Plan New things highlighted/boxed… So let’s look at a …

Password Resets No Longer Require a Thick Connection (Oracle Client) in SQL Developer

thatjeffsmith SQL Developer 9 Comments

Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database. Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available. A post I did up explaining this is one of the most read articles on …

Top 10 Posts of 2016

thatjeffsmith SQL Developer 0 Comments

Happy 2017! Here are your 10 favorite posts from last year. 1. Exporting Multiple Tables to Multiple Excel Spreadsheets Want 6 tables’ worth of data to go to single Excel file? Or one table per file? Here’s how to do that. 2. Oracle SQL Tuning Advisor and SQL Developer Own the Tuning Pack? Have SQL Developer? You should be using …

SQL Developer version 4.2 Early Adopter 2 Now Available

thatjeffsmith SQL Developer 16 Comments

Tons of bugs fixes based on your feedback, especially with the formatter. A few more changes with the formatter: we added more preferences for more flexibility we let you submit code to ‘shape’ the formatting preferences automatically we exposed the brains of the formatter so you can do pretty much whatever you want An example of the formatter ‘by example’ …

Custom SQLFORMATs with SQLcl

thatjeffsmith SQL Developer 8 Comments

When I make jokes about copying and pasting code from StackOverflow or Github, I’m not really joking. But in this case, it’s OK. Because, I’m copying and pasting code from OUR GitHub project, AND my boss wrote the code. A question came in, and it’s come in a few times, but here’s the most recent variant: @Rumtis no way – …

Latest Tips & Tricks

thatjeffsmith SQL Developer 4 Comments

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 demo added a few teasers for SQLcl I really, really need about 90 minutes to …

Viewing Automatic SQL Tuning Advisor Tasks in Oracle SQL Developer

thatjeffsmith SQL Developer 1 Comment

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 running already for several days now. I’m guessing their query hasn’t been running for several …