DEV Community

Naveen
Naveen

Posted on

Using SQL Developer Web (Database Actions) in ATP to Create Tables & REST APIs

#oracle #webdev

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:

  1. Connecting to ATP using Database Actions
  2. Creating a table using SQL Developer Web
  3. 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

Top comments (0)