Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE words2
- (
- word VARCHAR2(60)
- )
- TABLESPACE data_ts;
- --load the wordlist using your favorite tool, I used Toad Import wizard
- CREATE TABLE words
- TABLESPACE data_ts
- AS
- SELECT DISTINCT UPPER(word) word
- FROM words2
- WHERE REGEXP_LIKE(word, '^[a-zA-Z]{2,8}$') -- only letters play, no numbers or special characters
- AND MOD(LENGTH(word), 2) = 0; -- we only need word lengths that are divisible by 2
- DROP TABLE words2 PURGE;
Add Comment
Please, Sign In to add comment