Practice SQL with Oracle Live SQL
Oracle Live SQL: https://livesql.oracle.com
Oracle Live SQL is a web-based app that provides a SQL editor with a built-in Oracle database. It is created and maintained by Oracle and allows you to write and run SQL statements easily without having to set up your own Oracle database.
Here is a SQL script example for practicing SQL on Oracle Live SQL:
----------Create tables
create table project (
id number(18,0) primary key,
name varchar2(50) not null,
description varchar2(100)
);
insert into project
values (1,'Natural Language Processing', 'An AI project.');
insert into project
values (2,'Door Operating System', 'A system project.');
insert into project
values (3,'Bi Compiler', 'A system project.');
create table task (
id number(18,0) primary key,
name varchar2(50) not null,
description varchar2(100),
project_id number(18,0),
constraint fk_project foreign key (project_id) references project(id)
);
insert into task
values (1,'Create a workspace in VS Code', 'The solution for Natural Language Process using Python',1);
insert into task
values (2,'Create a solution in Visual Studio', 'The solution for Door Operating System using C and MAM',2);
insert into task
values (3,'Create a boot sector program ', 'The boot sector program will locate and load the Door OS',2);
create table developer (
id number(18,0) primary key,
firstname varchar2(30) not null,
lastname varchar2(30) not null
);
insert into developer
values (1,'Cuong', 'Nguyen');
insert into developer
values (2,'Nguyen', 'Cuong');
insert into developer
values (3,'Cuong', 'Cuong');
insert into developer
values (4,'Nguyen', 'Nguyen');
create table projectdeveloper (
id number(18,0) primary key,
startdate date,
project_id number(18,0),
developer_id number(18,0),
constraint fk_dev_project foreign key (project_id) references project(id),
constraint fk_dev_developer foreign key (developer_id) references developer(id)
);
insert into projectdeveloper
values (1, to_date('01/01/2023','mm/dd/yyyy'), 1, 1);
insert into projectdeveloper
values (2, to_date('02/02/2023','mm/dd/yyyy'), 2, 3);
insert into projectdeveloper
values (3, to_date('03/03/2023','mm/dd/yyyy'), 3, 2);
----------Retrieve data
select * from task;
select * from project;
select * from developer;
select * from projectdeveloper;
----------Delete table permanently
drop table project cascade constraints purge;
drop table task purge;
drop table developer cascade constraints purge;
drop table projectdeveloper purge;
#oracle #sql #livesql