CREATE TABLE ventas (  
     id_venta     NUMBER(6),  
     codigo_postal     VARCHAR(3)  
) 
 
 
 PARTITION BY LIST (codigo_postal)  
(  
     PARTITION norte  
        VALUES ('BCN'),  
     PARTITION centro 
        VALUES ('SLP'),  
     PARTITION sur  
        VALUES ('QRO') 
 )

CREATE VIEW LISTA AS SELECT TABLE_NAME,PARTITION_NAME, PARTITION_POSITION, HIGH_VALUE FROM USER_TAB_PARTITIONS WHERE TABLE_NAME ='VENTAS'

SELECT * FROM LISTA