/explore
|
You are here |
ral-arturo.org | ||
| | | | |
felipeelias.github.io
Thoughts on being a Senior Software Engineer |
|
| | | | | ||
| | | | |
mattspitz.me
software engineering musings |
|
| | | | | ||
| | | | |
raphaelhertzog.com
|
|
| | | | | ||
| | | | |
yorakb.wordpress.com
select extractValue(rws.object_value, '/ROW/TABLE_NAME') table_name, extractValue(rws.object_value, '/ROW/PARTITION_NAME') partition_name, to_date(substr(extractValue(rws.object_value, '/ROW/HIGH_VALUE'),11,11),'YYYY-MM-DD') high_value, extractValue(rws.object_value, '/ROW/NUM_ROWS') num_rows, round(extractValue(rws.object_value, '/ROW/BLOCKS')*8/1024) size_mb from ( select dbms_xmlgen.getxmltype('select table_name, partition_name, high_value, num_rows, blocks from user_tab_partitions') as x from dual ) ... |
|
| | | |||