Was helping someone on Stackoverflow this morning, and thought you might enjoy seeing this process as well. PROBLEM: You’ve created a schema script, you’ve generated the DDL, and you ran it on your brand-spankin’ new database. Except. Except, you ran that script as SYS, and your schema scripts didn’t have a SCHEMA defined. So you’ve corrupted your SYS schema!!! How to fix that (FLASHBACK!) is a different post. This post is about how to assign…
Things to know: MANY bug fixes The Windows Embedded JDK is now Version 8 update 181 You can have nested connection folders in the main and DBA connection panels Real Time SQL Monitoring reports can be exported to (non-flash) HTML Connections Some of you out there work with MANY databases, and so of course have tons of connections to work with in SQL Developer. Now you can have as many levels of folders as you…
The forwarding bit isn’t a new feature, but we have introduced new ORDS response header variables in version 18.3 of ORDS.You can now also read in the body of your request as a CLOB vs a BLOB. This post shows how to take advantage of both features. The only thing ‘new’ here is the name of this ORDS parameter. From the early days of the Oracle Application Express Listener, we always had X-APEX-STATUS-CODE and X-APEX-FORWARD.…
It’s easier to run things unsecured. It’s unconscionable to run things unsecured. DON’T BE THIS GUY. So Let’s Secure My Database and my Web Services So I have a collection of REST enabled objects (tables, view, and procedures) and a SLEW of RESTful Service modules. I want ALL of them locked down. So I need to create a Role and Privilege. And then I need to assign that privilege to what I want protected. Without…
The question: We have big database with a lot of stuff and I want to use version control (Git) to manage changes. There are a lot of articles how to do it step by step but one piece is missing for me. Is there standard or recommended way for file structure of whole database (data excluded) and how it can be obtained from existing database? So I’m not sure about standard or recommended, but we…
Slides Oracle REST Data Services: Options for your Web Services from Jeff Smith Video
I was using the Instance Viewer today and ran into the drill down for Storage. Let’s take a closer look at that report. I like this report enough, that I want to be able to run it in SQLcl. SQLcl is a command-line interface, so I’ll have to make a few changes. The links won’t work, boo. Those are easy to fix up – just remove the SQLDev:Link code. The Used (proportion) column is a…
A follower reached out to me late yesterday with this request: And the answer is yes, we can pretty much get there. I’ve noticed a few things by looking at his hand-formatted code on the bottom section. He prefers: everything lowercase right-aligned keywords no line breaks for the sub query ()’s no line breaks after SELECT/FROM/WHERE keywords So let’s go tell the formatter to follow these same rules. Note that all other formatter preferences are…
2021 Update: I originally wrote this post in 2018 – and since then I’ve taken on this type of question a few times. You might also enjoy these related posts, which are more technical/useful than a X in INT and Y out VARCHAR2 example like this: 4 ways to work with REF Cursors in your REST APIsORDS 101 for PL/SQL This from the YouTube:”Hi Jeff, Can you please share similar example where REST service is…
I’ll show you 3 cool tips and tricks for working with PL/SQL in SQL Developer…in under 7 minutes! In-code navigation – click into where your objects are declared Test Query – see if your SQL is gonna work BEFORE you compile it Using the Code Outline For those that can’t do video, basically you can Ctrl-Mouse-Hover Navigate ANYWHERE Not just on tables, but also on local variables. Right-Click to Test a Query Open and Use…
