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)