Oracle: Select PARTITION name
Example of how to select data along with name of the partition that the data is stored in
Tag: partition
Subpartition template
Use a subpartition template to automatically create subpartitions. –Create new table NEW_TABLE if this has not already happened DECLARE table_exists NUMBER :=0; BEGIN SELECT COUNT(*) INTO table_exists FROM USER_TABLES WHERE TABLE_NAME = ‘NEW_TABLE’; IF table_exists = 0 THEN EXECUTE IMMEDIATE(q'{ …