create alter rename desc select update delete insert

Oracle SQL 表操作示例

最新推荐文章于 2022-08-01 13:10:26 发布

孙瑞宇

最新推荐文章于 2022-08-01 13:10:26 发布

阅读量58

点赞数

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Mike_Chang/p/9281718.html

本文演示了如何使用 Oracle SQL 进行表的操作，包括创建表、修改表结构、插入数据、更新记录及删除记录等基本操作。通过具体实例展示了不同类型的 SQL 语句的应用。

conn scott/root;
create table student (id number(3), name varchar2(10), sex char(2), sno number(3));
alter table student add(sal number(7,2), birthday date);
alter table student modify(name varchar2(10));
alter table student drop column sal;
rename student to stu;
rename stu to student;
create table classes(class_id number(3), class_name varchar2(10));
desc student;
insert into student values(001, 'Tom', '男', 1, '22-4月-82', 100.50);
insert into student values(003, 'Mary', '女', 3, '24-5月-1988', 3000);
alter session set nls_date_format = 'yyyy-mm-dd';
insert into student values(004, '张三', '男', 4, '1997-7-1', 800);

insert into student values(005, '王五', '女', 5, to_date('1999-9-1','yyyy-mm-dd'), 900);
insert into student(id, name, sex) values(5, 'Test', '女');
insert into student(id, name, sex, birthday) values(6, 'Test2', '男', null);
select * from student where birthday is not null;
select * from student where birthday is null;
update student set name = 'Test_1' where name = 'Test';
update student set name = 'Test_2', birthday = '2000-9-9' where id = 6;
delete student where birthday = '1997-7-1';
delete from student where id = 5;

转载于:https://www.cnblogs.com/Mike_Chang/p/9281718.html