Version 18.1 of SQL Developer is now available. Go download that here. Most importantly, there are a TON of bug fixes in this release. Many of them reported on twitter, blog posts, and our forums. So thanks again for all that feedback. Today I want to talk about the first thing you’ll see, our new ‘Welcome Page.’ It used to look like this – Then it went to this – Make it better AND more…
SQL Developer’s code editors try to help you out. They’ll show you two categories of informational advisories: there is a problem with this code we think we can help you with this code These are shown by various styles of underlined text in the editor. Let’s go through the list of what’s available as of version 18.1 – to be released, soon 🙂 Actually all of these items, save 1, are available right now in…
The search feature in SQL Developer is whiz-bang. You’re using it, right? But what about at the command line? I’m guessing many of you just pluck away at ALL_ or DBA_OBJECTS. Some of you may have written some custom scripts. But, what if you burned that into SQLcl? You can of course do this with the ALIAS command. You can say, ALIAS XZY=query; And then access the query by just executing XZY. AND, you can…
When you AUTO-REST enable table in ORDS, we publish a full API for you: We auto find your Primary Key Column and use that to address particular rows (items) in your table (collection.) But..what happens if you don’t have a primary key? 459590870680e4b757a9b1_000003 REST enable that… 459590870680e4b757a9b1_000004 And now let’s ‘GET’ the table. So let’s try that… Hmmm, that ‘%2’ part doesn’t look right to me. That’s actually ‘%2B’ which is a way to escape…
The Automatic REST features in ORDS are very handy for getting started quickly with providing REST APIs to your data and stored procedures. Give me the data for an employee. Easy. REST enable the schema. REST enable the table. DO a GET on /ords/schema/table/id. But…I don’t want a ‘null’ in my JSON collection for value pair “commission_pct.” What’s an Oracle developer to do? Code/Roll your own REST Service. The ‘bespoke’ solution took me about 3…
A customer ‘ambushed me’ – how dare they!?! – at the conference today, needing help getting their scripts to work. So something like this: And the way the customer wants to run scripta.sql (which calls scriptb.sql) So, where is SQL Developer going to look for scriptA? And when it gets to the @child\scriptb.sql? We can call scripts.sql using @c:\users\jdsmith\desktop\parent\scriptA.sql But, we’re going to have a problem. So, you have 2 options. First, you COULD tell…
I see questions like this on StackOverflow and related websites like, ALL THE TIME: I have some code, what’s wrong with it? Something I wish I could do, other than physically hold the person’s hand, is show them how our IDE tries to point them in the right direction of their syntax issues. But since I can’t do that, I’ll write a quick blog post and help the Google gods can help folks going forward.…
You can now file bugs, sorry – submit Issues, for me on GitHub 🙂 What We’re Doing The intent is to build a nice library of How-To’s for ORDS. I’ve started with a section on PARAMETERS. ords-demo-parameters Build scripts to demonstrate working with parameters in your Oracle REST Data Services (ORDS) RESTful Services. This will demonstrate how to: Read a value in your GET handler SQL block from the request header Return a value via…
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. 459590870680e4b757a9b1_000011 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…
