PL/Scope is one of my favorite features. It answers SO many questions. Where am I declaring this, where am I calling that, when am I referencing something? And, I can get this information automatically, without hitting the big, fat SOURCE data dictionary views. I’ve talked about this previously… …BUT, PL/SCope didn’t help me with tracking the SQL I used in my PL/SQL. That is, it didn’t until 12cR2. Starting with Oracle Database 12c Release 2…
Want to get started on learning everything there is to know about the latest version of our Database? Don’t want to really have to install or create anything? Well, you’re in luck. Just go download our image. In a few minutes, you’ll be up and running with Database 12c Release 2. And APEX 5.1. And ORDS 3.0.9. And of course SQL Developer. Plus, you’ll get lots of Hands On Labs! Step by step instructions allow…
Want to export a ton of tables, but only get SOME of the records? Want to apply a GLOBAL filter across the tables to only get the records you want? Tools > Database Export. I’m going to export data, NOT DDL. I’m going to write it to a single JSON file. I’m going to grab data from a couple of tables. I ONLY want records from those tables where the CUSTOMER ID is in a…
Many of you might not know that most of what you can do in SQcl, can also be done in SQL Developer version 4.2. In fact, it’s the same code that handles running statements/scripts in SQLcl as it is in SQL Developer’s SQL Worksheet. Assuming of course, that you use THIS button. There’s one large exception to this. TODAY: we don’t allow you to use the SCRIPT command, yet. And one small exception: you can…
Reviewing my timeline, I came across this gem from Franc. I hate seeing SQL with keywords in uppercase and identifiers in lowercase. identifiers are case sensitive. Not keywords.— Franck Pachot (@FranckPachot) February 7, 2017 Franck isn’t alone – a lot of people hate it when their code doesn’t look the way they want it to. Many folks know about our formatter, and how to use it to get their IDENTIFIERS UPPER-CASED. But did you know…
A friend, let’s call her ‘Helen’ for the sake of this post, texted me the other day, wondering why she had all these dozens/hundreds (?) of files in her Windows home directory. She was confused. Where did they come from? Were they safe to delete? I asked her what they were called, and the filename sounded VERY MUCH like what she would have named her SQL Developer connection for a particular database. Now, it might…
Let’s say you have some files, stored as BLOBs, in your database, and you want to make them available via REST. So of course you install Oracle REST Data Services, and now you have two options: REST Enable the table or Deploy a custom RESTful service With the first option, I get an ‘automatic’ REST endpoint for my resource, which in this case is my table that has the BLOB, but I don’t want or…
Remember this fancy do-hickey? It’s the Instance Viewer. We introduced it as a new feature in version 4.1. For version 4.2, we added this – the Top SQL panel. We ask the database every 10 seconds what the most expensive query by CPU is. Maybe that’s a bit too aggressive for you? What if you only wanted to ask every…10 minutes? You can do this. You’ll want the Instance Viewer to be open and running,…
Dealing with a complex data type? Say, XML? Or, a nested table? If you want to see a ‘flat’ view of the data for that bit or a row when browsing a data set that contains that TYPE of data, you’ll want to check this preference. Using the code sample from OraFaq – thanks folks! – here’s what I mean. But, if we double-click on the cell… And after that click… If we ran this…
Someone on the Forums (yes, we read and respond!) noticed they couldn’t add Bytes or Time to their plan displays in Oracle SQL Developer. So we just made all of the columns available now, even if a few them might not make sense, i.e. TEMP_SPACE, OTHER. Preferences – Database – Autotrace/Explain Plan New things highlighted/boxed… So let’s look at a plan from V$SQL_PLAN…a la hitting this button – For AutoTraces you can also ask to…
