查询oracle分区表存在多少个分区oracle在分区查数据 查询oracle分区表存在多少个分区SELECT * FROM useR_TAB_PARTITIONS WHERE TABLE_NAME='TB_DS_TRADEINFO'; oracle在分区查数据select COUNT(*) from TB_DS_TRADEINFO partition(P1)