I have a RESTful Service that accepts a bind value to a query that ORDS will run for me. How do I pass that bind to ORDS? You can do it explicitly be defining it as part of the URI. Or, you can use the classic web ?var=value to pass it. ORDS supports both 🙂 The only difference is the URI itself. Easy, just include it on the call. So, which one to use? I…
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…
People seemed to like the Instance Viewer we built for version 4.1. So we wanted to use similar technology (Java FX) to build a new interface for the Oracle Database Tuning Pack’s Real Time SQL Monitor. So we did. If you don’t have EM Express or Enterprise Manager available or handy, you can get the report in all it’s live, refreshing glory, in SQL Developer’s DBA Panel. It’s also on the Tools menu. A Quick…
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…
I’m out on vacation this week, but you’re in luck. I have to do the Southwest 24 hour check-in thing, so that means I’m stuck on my laptop for a few minutes. If you’re a command-line kind of guy or gal, then you know all about SQL*Plus. If you’ve spent any time here, then you also know all about SQLcl – our new, modern CLI for Oracle Database. You’ve probably seen that the tool automatically…
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…
I’m lazy. I don’t like having to look up the directory name/structure when creating a new datafile. I don’t even like having to copy and paste it. So I avoid all of that, by using the CREATE LIKE dialog. View > DBA Add a connection. Open. Storage. Datafiles. Find one in the tablespace you want to add space for. Right-click. Now just fill in the details, or change things up as needed. Can’t Figure Out…
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…
Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database. Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available. A post I did up explaining this is one of the most read articles on this site – you can imagine how many users out there have expired passwords and…
Happy 2017! Here are your 10 favorite posts from last year. 1. Exporting Multiple Tables to Multiple Excel Spreadsheets Want 6 tables’ worth of data to go to single Excel file? Or one table per file? Here’s how to do that. 2. Oracle SQL Tuning Advisor and SQL Developer Own the Tuning Pack? Have SQL Developer? You should be using that then. BONUS POST: Viewing your automatic SQL Tuning Advisor Job Reports. 3. Can Oracle…