<commit_before>set echo on;
declare 
    blks VARCHAR(40);
    clouds VARCHAR(40);
    name VARCHAR(40);
begin

name := '&1';
clouds := name ||'_CLOUD';
blks := name ||'_BLOCK';

FOR i IN (SELECT table_name FROM user_tables WHERE table_name = clouds) LOOP
    EXECUTE IMMEDIATE 'DROP TABLE ' || clouds;
END LOOP;

FOR i IN (SELECT table_name FROM user_tables WHERE table_name = blks) LOOP
    EXECUTE IMMEDIATE 'delete from ' || blks;
    EXECUTE IMMEDIATE 'DROP TABLE ' || blks;
END LOOP;

execute immediate 'CREATE TABLE '|| clouds ||'(id number, CLOUD SDO_PC, BOUNDARY SDO_GEOMETRY)';
execute immediate 'delete from user_sdo_geom_metadata where table_name = '' || blks || ''';

end;
/

exit;<commit_msg>PURGE to ensure that dumped tables don't end up in the recycling bin<commit_after>set echo on;
declare 
    blks VARCHAR(40);
    clouds VARCHAR(40);
    name VARCHAR(40);
begin

name := '&1';
clouds := name ||'_CLOUD';
blks := name ||'_BLOCK';

FOR i IN (SELECT table_name FROM user_tables WHERE table_name = clouds) LOOP
    EXECUTE IMMEDIATE 'DROP TABLE ' || clouds || ' PURGE';
END LOOP;

FOR i IN (SELECT table_name FROM user_tables WHERE table_name = blks) LOOP
    EXECUTE IMMEDIATE 'delete from ' || blks;
    EXECUTE IMMEDIATE 'DROP TABLE ' || blks || ' PURGE';
END LOOP;

execute immediate 'CREATE TABLE '|| clouds ||'(id number, CLOUD SDO_PC, BOUNDARY SDO_GEOMETRY)';
execute immediate 'delete from user_sdo_geom_metadata where table_name = '' || blks || ''';

end;
/

exit;
{'fraction_non_alphanumeric': 0.11871227364185111, 'fraction_numerical': 0.009389671361502348, 'mean_word_length': 4.347670250896058, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4094928', 'n_tokens_mistral': 529, 'n_tokens_neox': 518, 'n_words': 175}