ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one. When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from …
Release News – What’s On Tap
SQL Developer has averaged about a single major release a year. We’ve also always had an Early Adopter or open beta where we would debut new features, and you could provide feedback. I think this worked – quite well even. But that’s over. Starting later …
Mandatory SQLDev Tip: Filter Your History
It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick …
How Do I Get My Charts Out of a Report?
Someone asked, I have this cool report, how do I get the chart out of it? For now I’ve been taking screenshots. So let’s look at how you can get your Report out to HTML (and a PNG.) When I say HTML, I mean you …
Generating a Data Dictionary Report and Diagram for a SubView
Your relational models can get big. Bigger than the human mind can easily consume. So instead of generating a report of 2,500 objects, you might want to break down your model to smaller chunks, AKA SubViews. So let’s open the reports, which you’ll find on …
Thoughts on GLOC Conference and ORDS/REST Demos
I had a very, very enjoyable time at the Great Lakes Oracle Conference this week in Cleveland (OHIO! – Just in case Joel is reading this.) About 400 people attended, and I think it’s become one of the best conferences in the US, esp for …
ORDS, RESTful Services, and $URI
Someone asked: I see reference to a ‘$URI’ in an ORDS GET Handler example, can you explain what this is? Yes. Or, I can with the help of some of our DOCS. The appropriate section would be: Columns in result sets whose first character is …
And…? Formatting in Version 4.2
“I do not want a line break after the and statement.” I’ve seen this come up a few times, so let’s answer that right now. SELECT 1 FROM dual WHERE 1=2 AND 2=3 AND 3=4 Default formatting changes that to SELECT 1 FROM dual WHERE …
Developing Oracle REST Data Services with SQL Developer 4.2
One of the new features in version 4.2 of SQL Developer is the ability to work with your ORDS Restful Services directly in the database tree. Here’s a video demo… Features via Screenshot Some of you don’t have access to YouTube at work (or at …
How to Save a Package and Package Body to a .SQL File
Got this question: Hello @thatjeffsmith ! How I save packege body and packege spec in same archive? #SqlDeveloper — Felipe Pereira (@FelipeR_Pereira) April 27, 2017 Answer: YES. Then set your file type. Now to confirm I’m really getting what I want. SQL Developer will automatically …