I’m running a week long poll on Twitter. After Google, where do you go for Oracle help, first? Please answer, then RT. If 'other', please specify in your RT.— Jeff Smith 🥃 ☜ (@thatjeffsmith) October 20, 2017 The problem with Twitter is that you’re limited to only 140 characters, so I’m afraid I failed to adequately word the question. My intent is to see where you go to ASK for help…literally. In the form of…
We released SQL Developer version 17.3 while I was at Oracle Open World, so I didn’t have time to really blog it. Plus, we found this REALLY annoying bug. Obviously this was ‘no bueno’ – so we put out a patch. Version 17.3.1 is available now. What’s New in 17.3? Mostly bug fixes. We identified issues from 17.2 and fixed those – thanks again Community folks! A few improvements. Code Outline It wasn’t working for…
A quick look at use the :body bind variable for grabbing the contents of your HTTP PUT or POST body on a REST API to insert a BLOB to an Oracle table.
Some of you are real fast typers, and don’t need this type of help. However, some of you, no matter how fast you can type, have to deal with column names that are long, hard to spell, and to just work with in general. So let’s say you’re working on a report, and the column order is very specific. Now, you could use the INSIGHT/POPUP feature, but those names come back in alpha order. Or…
I have 1,500 rows I need to shove into a table. I don’t have access to the database, directly. But my DBA is happy to give me a HTTPS entry point to my data. What do I do? Let’s look at a Low-Code solution: Oracle REST Data Services & Auto REST for tables. With this feature, you can say for a table, make a REST API available for: querying the table inserting a row updating…
Oracle REST Data Services happily converts your Oracle results to JSON for your REST APIs. But what if your results are already formatted as JSON? This post shows how to fix that!
We’ve just released version 17.3 of Oracle REST Data Services – as an Early Adopter (BETA). Go Download ORDS 17.3 Now. There are 2 major new features, and this post is about one of those: Swagger/OpenAPI style JSON for /metadata_catalog/ calls. Wait, why should I care about REST? The Movie Screenshots for Those that Can’t do YouTube at Work It’s fairly simple. Navigate to the /metadata-catalog/ URI for your RESTful Service. Then copy this {…JSON…}…
You have a schema. Someone else built it. You’ve just inherited it. Now you need to build an application around it. But, tell me more about this schema? No docs? That’s OK, you can build your own! 1. Connect to Your Database, Open a ‘Driving’ Table By driving, I mean one that’s likely to be at the ‘center’ of your business logic. An employees or sales table for example. Now, once it’s open, click on…
Think building REST Services for Oracle Database is hard? Tooling around SQL Developer, browsing data, and thought to yourself, that would make a great Web Service? Now, you can quickly publish the query behind a grid to a new or existing ORDS Module. Just right-click! (well wait a second, you need ORDS installed and configured for your database. And the user/schema should be REST enabled too.) Which brings up this dialog… …add it an existing…
Apparently SQL Developer doesn’t look super awesome on some Windows high-resolution displays (Macs are apparently A-OK!) 4 and 5k monitors. But that’s OK – it’s fixed in Java 9, and that appears to work just fine with SQL Developer v17.2. But another question came up – how can I make SQL Developer look…different? There isn't an overall theme for all the parts of the app? I really want everything changed (connections and reports).— PIONTΞKDD (@piontekdd)…