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 15 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 …

Filter All The Things

thatjeffsmith SQL Developer 4 Comments

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 I usually short change the subject in my talks. Today, let’s review all (most??) of …

User Defined Properties in SQL Developer Data Modeler

thatjeffsmith SQL Developer 5 Comments

There are tons of properties you can set in your design objects. In fact, I discovered a ‘new’ one this week thanks to my friend David. #Oracle #SQLDev Data Modeler users please up vote my feature request to allow additional “display as” componentshttps://t.co/2fIbVXmIn9::: — david schleis (@dschleis) October 12, 2016 Display as…what’s he talking about? Oh, this. But what if …

Demo: AutoTrace – Generate Hints and Compare Different Execution Plans & Stats

thatjeffsmith SQL Developer 6 Comments

For some reason I procrastinated setting up my video software on my new work machine. Big mistake. I put together this animated GIF to show some new things in version 4.2: Updated formatter – better support for ANSI joins Opening objects referenced in your execution plans Inserting Hints Not new but underutilized: how to compare plans/AutoTraces One Last Thing… …don’t …