?? oracle.sql
字號:
create table customer( id number primary key, name varchar2(20), password varchar2(20), zip varchar2(20), address varchar2(50), telephone varchar2(20), email varchar2(30));create table orderform( id number primary key, cost number(8,2), orderdate date, customerid number references customer(id));create table book( id number primary key, name varchar2(100), price number(8,2));create table orderline( id number primary key, num number not null, orderid number references orderform(id), bookid number references book(id));insert into book values(1,'JAVA核心技術(shù)',81.00);insert into book values(2,'UNIX技術(shù)手冊',21.15);insert into book values(3,'ORACLE9I參考手冊',108.00);insert into book values(4,'JSP設(shè)計(第三版)',59.25);insert into book values(5,'JAVA SERVLET 編程(第二版)',38.25);insert into book values(6,'XML 高級編程(第2版)',97.20);insert into book values(7,'精通STRUTS:基于MVC的JAVA WEB設(shè)計與開發(fā)',36.75);insert into book values(8,'精通HIBERNATE:JAVA對象持久化技術(shù)詳解',44.25);insert into book values(9,'SPRING IN ACTION中文版',29.25);insert into book values(10,'精通EJB 3.0',44.25);create sequence book_seq start with 1 increment by 1;create sequence customer_seq start with 1 increment by 1;create sequence orderform_seq start with 1 increment by 1;create sequence orderline_seq start with 1 increment by 1;
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -