A relatively new feature, Proxy User Authentication allows you to connect using someone else’s credentials. Or as Oracle-Base puts it: Since Oracle 9i Release 2 it has been possible to create proxy users, allowing you to access a schema via a different username/password combination. This is done by using the GRANT CONNECT THROUGH clause on the destination user. So I’m going to alter a user, SCOTT, to allow for this. 254367896681fc2ccd31dc_000000 Now, how do I…
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…
I’ve talked about the Cart a few times. It’s interesting to describe what the Cart is for, because it can be used or so many different things. But in general, it allows you do perform a set of operations against a collection of database objects. In this case I’m going to show you how to export several views and tables to an Excel file. And the rest of this blog post will be done using…
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.…
Yes, it’s that time of year again. Let’s take a quick look back at the posts (from 2017!) you read the most. SQL Developer v17.2 is now available SQL Developer v4.2 is now available Release News, What’s On Tap (where I announce our new numbering scheme) Real Time SQL Monitoring Update What is the Future of SQL Developer? Oracle Database 12cR2 is Now Available – and so is our new VirtualBox Appliance Developer Oracle REST…
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…
For 17.4, the formatter will attempt to format invalid SQL for you. If the parser runs into a problem recognizing your code, it will format it as much as it can. But that’s not all. It will ALSO go to the end of your statement, and traverse the SQL in the other direction and continue formatting as far as it can. Let’s look at an example: Before But hey, let’s format it anyway. Cause hey,…
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.
Developers hate using a mouse. Sticking with the keyboard reminds everyone we bled all over our keyboards 20 years ago in VT100 terminals. So we built a modern command line interface for Oracle Database and released it last year, in 2016. And knowing you already know and love the keyboard, we made sure you could do what you needed to do while building and running your scripts and statements. So here’s a video showing you…
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.
