DZone
Database Zone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
  • Refcardz
  • Trend Reports
  • Webinars
  • Zones
  • |
    • Agile
    • AI
    • Big Data
    • Cloud
    • Database
    • DevOps
    • Integration
    • IoT
    • Java
    • Microservices
    • Open Source
    • Performance
    • Security
    • Web Dev
DZone > Database Zone > Oracle Quick SQL Platform

Oracle Quick SQL Platform

With the Oracle Quick SQL Platform, software developers are able to generate SQL and test data very quickly and practically. Read on to learn how to use it.

Emrah Mete user avatar by
Emrah Mete
CORE ·
May. 11, 17 · Database Zone · Tutorial
Like (6)
Save
Tweet
4.89K Views

Join the DZone community and get the full member experience.

Join For Free

In this article, I will talk about Oracle's Quick SQL Platform.

Image title

SQL is very easy to write. It is one of the easiest languages to learn and code because it is the closest to human language. With the Quick SQL Platform, Oracle has taken a step forward, inheriting the inherent nature of the SQL language, to use a software that generates SQL with a much simpler notation. I considered it to be very useful in my first test and I think it can be quite useful in other tests. One of the most powerful features of this platform is that we can produce test data in the frame of the rules we set.

You only need an Oracle account to use this platform. If you do not have an Oracle account, you can get an Oracle account by following this link.

Let's give an example to provide a quick idea of how we can get an output by giving an input to the Oracle Quick SQL Platform.

As I said at the beginning of the article, it is a notation that Oracle has identified, and you can access the details of using this notation through the menus in the platform. (I will share the introduction link to the Oracle Quick SQL Platform at the end of the article.)

Example 1

Input:

departments   /INSERT 4 NAME /nn location employees / 
INSERT 1 NAME /nn vc50 email /lower cost center num date hired job

Output:

-- create tables
create table DEPARTMENTS (
    ID               NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY  
                     constraint DEPARTMENTS_ID_PK primary key,
    NAME             VARCHAR2(255) not null,
    LOCATION         VARCHAR2(4000)
)
;

create table EMPLOYEES (
    ID                 NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY  
                       constraint EMPLOYEES_ID_PK primary key,
    DEPARTMENT_ID      NUMBER
                       constraint EMPLOYEES_DEPARTMENT_ID_FK
                       references DEPARTMENTS on delete cascade,
    NAME               VARCHAR2(50) not null,
    EMAIL              VARCHAR2(255),
    COST_CENTER        NUMBER,
    DATE_HIRED         DATE,
    JOB                VARCHAR2(4000)
)
;


-- triggers
create or replace trigger EMPLOYEES_BIU
    before insert or update 
    on EMPLOYEES
    for each row
begin
    :new.EMAIL := LOWER(:new.EMAIL);
end;
/


-- indexes
create index EMPLOYEES_i1 on EMPLOYEES (DEPARTMENT_ID);
insert into DEPARTMENTS (
    ID,
    NAME,
    LOCATION
) values (
    1,
    'Customer Satisfaction',
    'Tanquecitos'
);

insert into DEPARTMENTS (
    ID,
    NAME,
    LOCATION
) values (
    2,
    'Finance',
    'Sugarloaf'
);

insert into DEPARTMENTS (
    ID,
    NAME,
    LOCATION
) values (
    3,
    'Office of the CEO',
    'Dale City'
);

insert into DEPARTMENTS (
    ID,
    NAME,
    LOCATION
) values (
    4,
    'Health',
    'Grosvenor'
);

-- load data
insert into EMPLOYEES (
    ID,
    DEPARTMENT_ID,
    NAME,
    EMAIL,
    COST_CENTER,
    DATE_HIRED,
    JOB
) values (
    1,
    3,
    'Gricelda Luebbers',
    'gricelda.luebbers@aaab.com',
    82,
    sysdate - 55,
    'Systems Software Engineer'
);

With this platform, software developers are able to generate SQL and test data very quickly and practically. You can reach the Oracle Quick SQL Platform by following this link.

sql

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Common Types Of Network Security Vulnerabilities In 2022
  • Are Foreign Keys Unscalable?
  • Python 101: Equality vs. Identity
  • What Is Edge Compute? It’s Kind of Like Knitting Dog Hats

Comments

Database Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • MVB Program
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends:

DZone.com is powered by 

AnswerHub logo