oracle 建用户

--创建用户.
create user java identified by java ;
--授权
grant connect , resource to java;

--创建表
create table weatherdata
(
 cityId int not null ,
 inputTime varchar(20) not null ,
 cityArea varchar (20) not null,
 cityWeather varchar (50)
);

-- 创建 sequence.
create sequence sequence_cityID start with 1  increment by 1 maxvalue 1000000000000 ;
-- 插入数据 .

insert into weatherdata(cityId,inputTime,cityArea,cityWeather) values(sequence_cityID.nextval,'xxx-xx-xx','西安','多云 风力2级别');

oracle中还有很多的命令、这就不一一列举了、百度和谷歌上都特别的多、只是在用的时候看看就是了。