ORACLE 创建表，插入值
时间:2014-09-18 00:33 来源:linux.it.net.cn 作者:it
ORACL创建表：
create table book(bookid char(10) not null,bookname varchar2(60),price number(5,3))
使用下面的语句来插入数据
INSERT INTO BOOK(bookid,name,price) VALUES('100123','oracle sql',54.70);
INSERT INTO BOOK VALUES('100123','oracle sql',54.70);
INSERT INTO BOOK(bookid) VALUES('100123'); (责任编辑：IT)
| ORACL创建表： create table book(bookid char(10) not null,bookname varchar2(60),price number(5,3)) 使用下面的语句来插入数据 INSERT INTO BOOK(bookid,name,price) VALUES('100123','oracle sql',54.70); INSERT INTO BOOK VALUES('100123','oracle sql',54.70); INSERT INTO BOOK(bookid) VALUES('100123'); (责任编辑：IT) |