insert into hash_tab(order_id, sernum, state_code) values (1, '111', 'MA'); insert into hash_tab(order_id, sernum, state_code) values (2, '222', 'TX'); insert into ...
CREATE TABLE sales ( dept_no number, part_no varchar2, country varchar2(20), date date, amount number ) PARTITION BY HASH (part_no) ( PARTITION p1, PARTITION p2, PARTITION p3 ); The table will return ...