List Partitioning List partitioning enables you to explicitly control how rows map to. partitions.
{"Image DocumentName": "List PartitioningList partitioning enables you to explicitly control how rows map to. partitions.", "Image ImageDescription": "You do this by specifying a list of discrete values for the partitioning key. in the description for each partition. This is different from range partitioning, where a range of values is. associated with a partition and from hash partitioning, where a. hash function controls the row-to-partition mapping. The advantage of list partitioning is that you can group and organize unordered and unrelated sets of data in a natural way. CREATE TABLE sales_list. (salesman_id NUMBER(5), salesman_name VARCHAR2(30), sales_state VARCHAR2(20), sales_amount NUMBER(10), sales_date DATE) PARTITION BY LIST(sales_state) ( PARTITION sales_west VALUES IN (\u2019California\u2019, \u2019Hawaii\u2019), PARTITION sales_east VALUES IN (\u2019New York\u2019, \u2019Virginia\u2019, \u2019Florida\u2019), PARTITION sales_cent VALUES IN (\u2019Texas\u2019, \u2019Illinois\u2019) )", "Image XResolution": "37", "Image YResolution": "37", "Image ResolutionUnit": "Pixels/Centimeter", "Image Software": "SlidePlayer", "Image YCbCrPositioning": "Centered"}