INSERT into TEL_SEGMENT_TT(TEL,PROVINCE,CITY,"OPERATOR")VALUES('asdasddgff','北京','北京','中国移动')
INSERT into TEL_SEGMENT_TT(TEL,PROVINCE,CITY,"OPERATOR")VALUES('asdasddgff','上海','上海','中国联通')
SELECT * from TEL_SEGMENT_TT partition(TTS_BEIJING)
SELECT * from TEL_SEGMENT_TT
SELECT * from TEL_SEGMENT_TT partition(TTS_SHANGHAI)
UPDATE TEL_SEGMENT SET PROVINCE='天津' ,CITY='天津' WHERE ROWNUM IN(SELECT NI from (select rownum NI,A.* FROM TEL_SEGMENT A) WHERE NI>10000 AND NI<20000)
INSERT into TEL_SEGMENT_TT(TEL,PROVINCE,CITY,"OPERATOR")VALUES('asdasddgff','上海','上海','中国联通')
SELECT * from TEL_SEGMENT_TT partition(TTS_BEIJING)
SELECT * from TEL_SEGMENT_TT
SELECT * from TEL_SEGMENT_TT partition(TTS_SHANGHAI)
UPDATE TEL_SEGMENT SET PROVINCE='天津' ,CITY='天津' WHERE ROWNUM IN(SELECT NI from (select rownum NI,A.* FROM TEL_SEGMENT A) WHERE NI>10000 AND NI<20000)