oracle function update,oracle如何把update(含max函数的语句)改为merge into呢

最新推荐文章于 2024-07-04 19:03:05 发布

十七卷

最新推荐文章于 2024-07-04 19:03:05 发布

阅读量333

点赞数

文章标签： oracle function update

C# codecreate table DATA_MODEL_FINAL

(

OBJID NUMBER not null,

OBJUSERID VARCHAR2(20),

OBJELEVATION FLOAT,

GROUPID VARCHAR2(20) default 0

);

create bitmap index GROUPID_model_index on data_model_final(GROUPID);

create unique index objuserid_index on data_model_final(objuserid);

create table DATA_PIPE_FINAL

(

OBJID NUMBER not null,

STARPOINTELEVATION FLOAT,

GROUPID VARCHAR2(20) default 0,

START_POINT VARCHAR2(20)

);

create index START_POINT_index on data_pipe_final(START_POINT);

create bitmap index GROUPID_pipe_index on data_pipe_final(GROUPID);

insert into DATA_MODEL_FINAL (OBJID,OBJUSERID,OBJELEVATION,GROUPID) values (1910615,'AJ31123',0,'0201');

insert into DATA_MODEL_FINAL (OBJID,OBJUSERID,OBJELEVATION,GROUPID) values (1910616,'AJ31124',0,'0202');

insert into DATA_MODEL_FINAL (OBJID,OBJUSERID,OBJELEVATION,GROUPID) values (1910617,'AJ31125',0,'0203');

insert into DATA_MODEL_FINAL (OBJID,OBJUSERID,OBJELEVATION,GROUPID) values (1910618,'AJ31126',0,'0204');

insert into DATA_MODEL_FINAL (OBJID,OBJUSERID,OBJELEVATION,GROUPID) values (1910619,'AJ31127',0,'0204');

insert into DATA_MODEL_FINAL (OBJID,OBJUSERID,OBJELEVATION,GROUPID) values (1910620,'AJ31128',0,'0204');

insert into data_pipe_final (OBJID,START_POINT,STARPOINTELEVATION,GROUPID) values (201101,'AJ31126',1.5,'0104');

insert into data_pipe_final (OBJID,START_POINT,STARPOINTELEVATION,GROUPID) values (201102,'B000001',1.8,'0101');

insert into data_pipe_final (OBJID,START_POINT,STARPOINTELEVATION,GROUPID) values (201103,'AJ31126',2.2,'0104');

insert into data_pipe_final (OBJID,START_POINT,STARPOINTELEVATION,GROUPID) values (201104,'AJ31126',1.5,'0104');

insert into data_pipe_final (OBJID,START_POINT,STARPOINTELEVATION,GROUPID) values (201105,'AJ31127',1.5,'0104');

insert into data_pipe_final (OBJID,START_POINT,STARPOINTELEVATION,GROUPID) values (201106,'AJ31127',1.9,'0104');

关注