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
Auf dieser Seite können Sie das Online-Video Practice SQL with Oracle Live SQL mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer cyberNet 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 995 Mal angesehen und es wurde von 14 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
