Developing Oracle REST Data Services with SQL Developer 4.2

thatjeffsmith SQL Developer 4 Comments

Tell Others About This Story:

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.

oracle rest data services modules

Note the ‘REST Data Services’ item on the tree.

As you make changes here, the REST Services, assuming they’re published and ORDS is actually running, are affected immediately.

I really like this part, if you know SQL or PL/SQL, you can create a RESTful Service.

See my other recent ORDS posts to get an idea of what you can do in terms of defining parameters, defining POST or PUT handlers, etc.

Related Posts

Tell Others About This Story:

Comments 4

  1. Any help on something simple like updating a table in oracle cloud would be appreciated. I would like to run a sql statement but am having difficulty connecting to a table with oracle sql developer. I am able to see the table in bi

    1. thatjeffsmith Post
      Author
    2. hcm cloud version 12. Most articles say we arent able to issue update sql to those tables. The table I am trying to fix is pay_all_payrolls_f in the fusion schema. Is it possible to use rest api to run a sql command? thanks

    3. thatjeffsmith Post
      Author

      No idea. I’m not sure they have ORDS up and running there for folks to build custom REST APIs or not. The apps side of the house is a completely different line of business.

      But.

      I would be EXTREMELY surprised if they let you do that.

      Have you considered opening a support ticket to get your table fixed?

Leave a Reply

Your email address will not be published. Required fields are marked *