As always our team will be quite busy, with both social and technical activities. And in case you forgot, I’m on the team that brings you: Oracle SQL Developer SQL Developer Data Modeler SQLcl REST Data Services A ton of database service instance console UIs (including the upcoming SQLDev Web) OTN Developer Day VirtualBox Appliance Lots of fun source code, samples, and docs on GitHub Projects I can’t talk about yet The Talks We have…
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…
Don’t have direct access to your Oracle Database, but do have Oracle REST Data Services? Your Java apps can make JDBC connections via our mid-tier with our REST Driver! Here’s an example with SQLcl.
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…}…
In the year 2000… No, let me start over. IN the year 2017, we have Oracle SQL Developer version 17.2. It started as Project Raptor in 2005. It’s got a pretty wide and deep feature set covering these areas: PL/SQL IDE SQL editor GUI for browsing and managing database objects Ad Hoc reporting Database Design & Data Modeling Database Administration 3rd Party RDBMS Migrations to Oracle Deploy and Administer Oracle REST Data Services REST Enablement…
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…
I get the impression that many of you have thought about getting more acquainted with our development tools and platforms here at Oracle. But I ALSO get the impression that many of you just haven’t had the time. So, I’m officially inviting you to participate in a series of upcoming webinars I’ll be hosting. How they ‘work’ We’ll use a online conference solution that lets me share my desktop with you. I’ll be doing live-demo…
Customer asks: We tried also to apply some naming conventions but I think we didn’t understand something…. Having a logical model with a table having the column X, and a glossary having the standard name as Y. Can I apply some checks based on the glossary directly in the logical or relational model? Yes, in fact you can. Basically how it will work is: You will define a glossary, having words you approve for your…
Time to download! Mostly bug fixes. the frequent ‘connection reset’ message should be GONE entering text data in a data grid cell and the cursor doesn’t advance should be FIXED having a @ or a ; in a comment in your query should work AGAIN many, many more bug fixes – see the release notes for details SQLcl updated, more bug fixes ORDS 3.0.10 is included, even more bug fixes + Auto PLSQL feature Brand…
Here’s a 15 minute video showing you everything you need to know about using the data grids in Oracle SQL Developer. Basically: settings fonts and look & feel column sizing column(s) sorts client side filtering copy & paste tricks single record view complex data type support – Spatial & BLOBs dates & timestamps inserting multiple rows via PASTE I do NOT talk about the EXPORT feature – because then it would be a 30 minute…
