oracle 在线练习平台

 oracle官方的服务 Live SQL，需要先注册一个帐号。

访问地址： Oracle Live SQL

Oracle Live SQL - SQL Worksheet

 建立简单学生表测试一下平台运行

create table student(

name varchar2(20),

age number(3)

);

 


insert into student values('Tom', 18);

insert into student values('张三', 20);

insert into student values('李四', 22);

insert into student values('王五', 26);

 


select * from student;

 


desc student;

 


drop table student;

 


delete from student;

 


delete from student where age=20;

 


commit;

运行成功