If you're working on Oracle Autonomous Transaction Processing (ATP), one of the most powerful tools available is SQL Developer Web, also called Database Actions. It allows you to manage your database entirely from the browser no installation required.
In this blog, I'll walk you through:
- Connecting to ATP using Database Actions
- Creating a table using SQL Developer Web
- Enabling REST APIs automatically using ORDS
What is SQL Developer Web (Database Actions) ?
Oracle provides a browser based interface called Database Actions, which is essentially an online version of SQL Developer.
It allows you to:
- Run SQL and PL/SQL
- Create tables and objects
- Build REST APIs
- Monitor performance
- Load data and manage users
Step 1: Access Database Actions
Ensure you have ATP wallet (zip file).
When you zipped it. You will find that the README file. In that file you will see an URL below the Database Actions.That URL helps us to login into SQL Developer.
FYR, Login Page of Web sql Developer
Step 2: Open SQL Worksheet
Once inside:
Click: SQL → Have a Tour !!
Playground for your action
Step 3: Create a Table
Run the sql
CREATE TABLE nj_dump (
name VARCHAR2(200),
num NUMBER,
dob DATE,
email VARCHAR2(200)
);
Insert you can perform on your tables
Hey you know I learnt new way to insertion with below stmt
INSERT INTO NJ_DUMP
VALUES ('Naveen Jejji', 567, DATE '2003-06-12', 'njejji@ok.com');
Step 4: Enable REST API
Now we use same table which we created earlier and enable rest.
- You can search your table in Navigator panel as
Right Click on your table , you will get few more options among them .Choose the REST
Once you done with REST selection, you will be able to get the Curl options like below
Tooke entire curl and Paste in your POSTMAN application and provide necessary authentications details as below
We are Done
Try yourself for POST operation from POSTMAN applications.
In the next blog, I will cover the how we call this in our modern VBCS