Guest User

Untitled

a guest
Oct 17th, 2017
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. CREATE TABLE words2
  2. (
  3. word VARCHAR2(60)
  4. )
  5. TABLESPACE data_ts;
  6.  
  7. --load the wordlist using your favorite tool, I used Toad Import wizard
  8.  
  9. CREATE TABLE words
  10. TABLESPACE data_ts
  11. AS
  12. SELECT DISTINCT UPPER(word) word
  13. FROM words2
  14. WHERE REGEXP_LIKE(word, '^[a-zA-Z]{2,8}$') -- only letters play, no numbers or special characters
  15. AND MOD(LENGTH(word), 2) = 0; -- we only need word lengths that are divisible by 2
  16.  
  17. DROP TABLE words2 PURGE;
Add Comment
Please, Sign In to add comment