I wrote this on LinkedIn, but that platform doesn’t play nice with Flipboard, and not all of you are connected with me there. So, if you Twitter, take a second and follow these people. You can thank me later. If you’re looking to follow even MORE people, go read that story, and you’ll see how to fine 194 more.
Updated 26 April 2022 ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one. Need help with “The pool named: |default | is invalid and will be ignored” ?Try this post, Troubleshooting ORDS startup errors, the pool is invalid 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 ORDS_PUBLIC_USER…
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 will save you so much time, you’ll be mad I didn’t make you learn it earlier. Apply a Filter to Your SQL History Next week we’re going to work on…
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 have a SQL Dev report that’s generated by SQL Developer itself. I am NOT talking about DBMS_OUTPUT reports that you can use to physically print HTML3 code and have it…
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 the bang you get for your buck. I did two talks. For the first one, they had me in the ‘big’ room – right after the day’s Keynote. The Keynote…
Generating Links with Oracle REST Data Services with both SQL (GET) and PL/SQL (POST) examples.
You can’t REST if you don’t HATEOAS, so you need to know how to generate hyperlinks in your JSON responses for your REST APIs.
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 home apparently), so here’s a quick snapshot. As you make changes here, the REST Services, assuming they’re published and ORDS is actually running, are affected immediately. See my other recent…
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 open the file after it’s created.
Love the command line? Hate ugly, out-of-the-box formatting of your results? You’re in luck, we have just the thing for you: Oracle SQLcl. It offers the ability to auto-pretty up your SQL results to the screen. Here’s a quick video overview of what that is, and how it works. For those of you w/o access to YouTube How do you get through your day w/o cat videos and Marvel Studios movie trailers? Anyways, here’s a…
Password resets. It used to be a pain – it required installing and configuring an Oracle client. But, no more! Simply get version 4.2, and you’re good to go. Here’s the video. So go get version 4.2 already.
