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')
)
Table created.
CREATE VIEW LISTA AS SELECT TABLE_NAME,PARTITION_NAME, PARTITION_POSITION, HIGH_VALUE FROM USER_TAB_PARTITIONS WHERE TABLE_NAME ='VENTAS'
View created.
SELECT * FROM LISTA
| TABLE_NAME | PARTITION_NAME | PARTITION_POSITION | HIGH_VALUE | VENTAS | NORTE | 1 | 'BCN' | VENTAS | CENTRO | 2 | 'SLP' | VENTAS | SUR | 3 | 'QRO' |
|---|