ThatJeffSmith

Category: Database Stuff

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

Similar Posts by Subject Areas: , ,

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: , , ,

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 instead. Click on the Column, and toggle it to USER_ID. […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,