1.查询行号大于某一值的数据
SELECT “ID”, “CODE”, “NAME”, “COLUMN_NAME”, “COLUMN_TYPE”, “ELEMNENT_CODE”, “TABLE_NAME”, “CREATEDATE”, “SEQNO” FROM
(
SELECT rownum no,“ID”, “CODE”, “NAME”, “COLUMN_NAME”, “COLUMN_TYPE”, “ELEMNENT_CODE”, “TABLE_NAME”, “CREATEDATE”, “SEQNO”
FROM “XNY_FJ”.“XNY”.“EE_DYNAMIC_TABLE_STAT” WHERE rownum<=1596 ) WHERE no >1575;
2.将一张表的数据插入到另一张表中
INSERT INTO XNY.RSYS_MENU_BUSINESS
(“ID”,“BMENU_NAME”,“LINK_URL”,“DIRECTION”,“BMENUTYPE”)
SELECT “MENU_ID”, “MENU_NAME”, “LINK_URL”, “DIRECTION”, “MENUTYPE”
FROM XNY.RSYS_MENU
WHERE LINK_URL IS NOT NULL AND LINK_URL!=’’;
3.将一张表中的数据更新到令一张表中
UPDATE XNY.RSYS_MENU
SET XNY.RSYS_MENU.LINK_URL = XNY.RSYS_MENU_BUSINESS.ID
FROM XNY.RSYS_MENU ,XNY.RSYS_MENU_BUSINESS
WHERE XNY.RSYS_MENU.MENU_ID = XNY.RSYS_MENU_BUSINESS.ID;
4.创建索引
create index EE_DYNAMIC_TABLE_DESC_INDEX on xny.EE_DYNAMIC_TABLE_DESC(OBJID,CODE,KPI_TYPE);