I’m new to Oracle, and I need a database…help!
Database Stuff

I’m new to Oracle, and I need a database…help!

Taking an Oracle Database class or course? Need to get up and going on Oracle Database really fast, and really easily? Here’s my advice!

Read More
REST APIs and TABLE INSERTs: the Definitive Guide for Oracle
ORDS

REST APIs and TABLE INSERTs: the Definitive Guide for Oracle

REST APIs and TABLE INSERTs, everything you need. Bonus: we’ll build a REST API to GET the data, with support for CLOB/JSON, links, and exception handling!

Read More
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? you don’t need all the columns columns can change columns can be added columns can be removed At some point, your…

SQL Developer

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 now added DESC. And then I ran a few commands that use those blacklisted commands. Now let’s check our HISTORY.…

SQL Developer

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 that’s cool. Now let’s show you how to view multiple files/objects/documents/windows at once. So, you can use this trick to…

ORDS

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 about the SELECT and GET bits before. What I’m going to show today is how to POST (INSERT) up a…

SQL Developer

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. When I click ‘Apply’ or ‘OK’ – the generated column goes away. If you don’t like being asked, you can…

SQL Developer

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 the set of values we give you for a table or column property aren’t enough? What…

SQL Developer

We introduced the Instance Viewer in v4.1. We show you in real time what’s happening in your database. To get there, open your DBA panel. Connect. Then go to the Database Status node. Storage bits are interesting, but maybe you’re more excited about the specific workload. So in version 4.2, we’ve added a Top SQL panel to the screen. It auto-refreshes every few seconds, and you can sort it by several different performance metrics. If…

SQL Developer

I love SQLcl – I use it more and more every day. But. Sometimes I need a GUI. Copying and pasting code between the two can be cumbersome – Toggle the Block Cursor You can do this in v4.1 with the mouse and clicking to set the cursor points. In v4.2 you can do it by toggling the block cursor mode, and then it’s all keyboard from there. I have a standing ER to be…

SQL Developer

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 forget about the HotSpot feature we added in v4.1.