So you’ve installed ORDS, you’ve REST enabled a schema, and you’ve started publishing some RESTful Services. Now, how do we go about seeing what’s what? If you’re using ORDS to build ORDS REST APIs with Database Actions, AKA SQL Developer Web, simply navigate to the REST page under development. There you can find a modules page, and select your REST Module. Browsing ORDS REST Module Templates… You could search using SQL Developer Desktop’s Find DB…
When executing scripts in SQL Developer, the amount of output we display on the screen is LIMITED. By design, we only show you 5,000 records from any query, and we limit the amount of output in total for a single script execution to 10,010 rows. This is controlled here: I know what you’re thinking… Why? A few reasons, but practicality is what it boils down to. Displaying 3M rows of script output in a GUI…
In this 10 minute video I’ll show you: how to open a panel how to move a panel how to reset your desktop if something gets ‘borked’ how to create new desktop tab groups (for docking things) AND how to ‘float’ your doc or panel to a secondary monitor Welcome 2018! Please be sure to subscribe to my YouTube channel if you want to keep up to date on the latest video tips and tricks.…
You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common. And as a child of the 80’s television, my brain has been properly warped. So here is your Christmas themed SQL Developer ‘trick.’ Every look under the tree, and your first reaction is to be a little disappointed in the number or shape of packages left for you? Have a SPEC but No Body?…
Mixing things up today with a quick Q&A with the guy that that generates most of the Google results to your pressing Oracle ‘how do I…?’ questions. Tim isn’t just a walking website, he’s also a great communicator. If you haven’t had a chance to see him speak at an Oracle conference, it’s probably because you don’t go to Oracle conferences – he gets around! Make sure you follow him on Twitter, subscribe to his…
In SQL Developer you can configure how you want things to work for your session. How DATES should appear. If numbers should use a ‘.’ or a ‘,’ to indicate group separators and decimal points. We try to guess these things based on your local machine settings, but you can of course override them. But let’s see what happens when you DO set something. I’m going to change a whole bunch of stuff, stuff that’s…
I’ve got short videos for you, 2-10 minutes. I’ve got 20 minute videos. And I’ve got monster, hour long videos. 24 in total, covering everything from how to use the PL/SQL debugger, to building REST Services, to just writing better SELECT * queries. Send me your requests, always happy to build more. I just wish I had a voice made for radio to accompany the face. Just click here to peruse the videos.
I needed to publish a blog post this week, but instead of writing new content, I thought I’d share with you things I’ve written in other places. In no particular order: I Installed SQL Developer, Now What? – Medium REST for the DB Professional – What’s in it for you? – UKOUG Scene Automatic REST – Oracle Magazine Are Oracle’s Database Tools as good as Toad? – Quora Is Online Advocacy Making me a Grouch?…
Someone asked about persisting table filters. Quick answer, we don’t. When you leave and come back to table, the filters are no longer active. Don’t know what I mean by filters? So, if you close the table and come back, the filter won’t be there anymore. MOSTLY. It is there, you just have to ask for it. Ctrl+Space. Now scroll down. Down further. Past the column list.
I wrote recently about using REST to upload a file to your table with ORDS. I want to extend that and share more code. I want you to see how to not only load the pics, but then how to get a collection of items, with links to those items, and in this case, also links to the media (pics) which we’ve uploaded. AND IT’S SO LITTLE CODE. What I’ll share: table ddl a few…
