oracleÁ·Ï°£¨mldnÊÓƵ£©¶þ

´´½¨±í
create table person (pid int,name varchar2(20) unique,
age int check(age between 0 and 150),sex varchar(4) default 'ÄÐ',tp int,
address varchar(200),constraint person_pid_pk primary key(pid));
²åÈëÊý¾Ý
insert into person values(0011,'ÁõÈý½ã',25,'ÄÐ',13930123021,'ºÓ±±Ê¡ÇúÑôÏØ');
´´½¨×Ó±í
create table book(bid int primary key not null,bname varchar2(20),bprice number(5,2),pid int,
constraint person_book_pid_fk foreign key(pid) references person(pid));
²åÈëÊý¾Ý
insert into book values(0101,'¼ò°®',7.85,0011);
Ôö¼Ó²¿ÃÅ50
select * from dept;
insert into dept values(50,'HR','HOUSTON');
ÔÚempÖвåÈëÐÂÊý¾Ý
insert into emp(empno,ename,job,sal,mgr,hiredate,comm,deptno)
values(8888,'ÕÅÈý','¾­Àí',9000,null,sysdate,null,50);
ROWNUM
²éѯǰÎå¸öÊý¾Ý
select rownum,empno,ename,job,sal,hiredate
from emp where rownum<=5;
select * from
²éѯºóÎå¸öÊý¾Ý
(select rownum rn,empno,ename,job,sal,hiredate from emp
where rownum <=10 ) temp
where temp.rn>5;