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 …

7 Ways to Avoid SELECT * FROM Queries in SQL Developer

thatjeffsmith SQL Developer 8 Comments

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, 2016 But wait, what’s wrong with SELECT * FROM queries? you don’t need all the …

Creating an Oracle REST Data Services User with the ‘SQL Developer’ Role

thatjeffsmith ORDS 12 Comments

Want to publish some RESTful services using SQL Developer and Oracle REST Data Services (ORDS)? You’re in luck! View > REST Data Services > Development. Before you can do this, a few things. you’ll need to install and run ORDS you’ll need to REST enable a schema you’ll need to have created an ORDS user with the ‘SQL Developer’ role …