ThatJeffSmith

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, 2016 But wait, what’s wrong with SELECT * FROM queries? […]

Similar Posts by Subject Areas: , , ,

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: So I previously added ALTER to the list, and just […]

Similar Posts by Subject Areas: ,

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 what I’m talking about. This works for tables too! So […]

Similar Posts by Subject Areas: , , , ,

REST Enabling Your Tables: Insert Rows via POST

One of the coolest features of Oracle REST Data Services v3.0 and higher, is the ability to REST enable your Oracle tables and views. You get a full REST api on your table – INSERT, UPDATE, DELETE, Select with or without predicates and sorting, and getting metadata. You can also batch load records. I’ve talked […]

Similar Posts by Subject Areas: , ,

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

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 […]

Similar Posts by Subject Areas: , , ,

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 I usually short change the subject in my talks. Today, […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,