oracle 创建表

 

create table test (
NAME VARCHAR(20),
AGE NUMBER(10)
)

SELECT * FROM TEST
--INSERT INTO TABLE_NAME VALUES (COL1,COL2,...)
INSERT INTO test values ('SHANG','30')
--INSERT INTO TABLE_NAME (COL1NAME,COL2NAME) VALUES (COL1,COL2)
insert into test (name,AGE) values('CHEN',20)

posted on 2020-11-17 15:44  joeshang  阅读(364)  评论(0编辑  收藏  举报

导航