--创建学生表 create table StudentTable ( studentID varchar2(50) not null, studentName varchar2(50) not null, studentSex char(4) default '男', studentAge number(3,0), studentNative varchar2(50), studentDepartment varchar(50), sudentBirthday date, constraint PK_StudentTable_studentID primary key(studentID), constraint check_studentSex check(studentSex in ('男','女')), constraint check_studentAge check(studentAge > 1) ); --插入数据 insert into studenttable values('s001','孙悟空','男',20,'花果山','少林派', to_date('2011-12-2','yyyy-mm-dd')); insert into studenttable values('s002','猪八戒','男',15,'高老庄','月亮上', to_date('2001-10-20','yyyy-mm-dd')); insert into studenttable values('s003','沙悟净','男',26,'流沙河','黑龙江', to_date('1903-1-02','yyyy-mm-dd')); insert into studenttable values('s004','唐三藏','男',21,'长安城','龙门庙', to_date('1991-01-30','yyyy-mm-dd')); select * from studenttable2 --查找数据 select studentID,studentName,studentSex,studentAge,studentNative,studentDepartment,to_char(sudentBirthday,'yyyy-mm-dd') from studenttable; --删除一张表(把标的结构和表的数据一起删除) drop table StudentTable ;
oracle中创建表时date,oracle创建带有时日期字段的表
最新推荐文章于 2024-06-03 10:38:06 发布