oracle 常用语法

分组排序

使用：ROW_NUMBER() 函数的时候，记得又是新的select 结果集

select a1.*   FROM (SELECT ROW_NUMBER() OVER(PARTITION BY b.OFFER_INS_ID ORDER BY b.OFFER_INS_ID desc) RN, b.* FROM cvt.um_price_plan_852_20200106_no b ) a1 where RN=1;

select * from DBA_jobs; 查看存储过程

SELECT * FROM DBA_DB_LINKS；-- 查看链接

SELECT * FROM ALL_TABLES T WHERE T.TABLE_NAME LIKE '%PENDIN%';--查找用户下的表

select * from all_sequences WHERE sequence_owner='RES';--查找索引

select * from all_sequences WHERE sequence_owner='INS1' AND SEQUENCE_NAME LIKE'%BUNDLE%';--查找索引