I've been looking at an old thread<https://groups.google.com/forum/#!searchin/oracle-plsql/permutations/oracle-plsql/igKzZnzm4hQ/IGuxrOxbuAkJ>which almost but not quite works for a problem I have.
Given a phase, and a table of "like" words, essentially a thesaurus, I'd like to generate all permutations of the phrase making use of the thesaurus entries. As an example... create table word_thes (value varchar2(30), likeness varchar2(30)) / insert all into word_thes values ('red','rouge') into word_thes values ('red','crimson') into word_thes values ('car','motor') into word_thes values ('car','vehicle') select 1 from dual / So here I'd like to find options for "big red car" Desired output is: big rouge car big rouge motor big rouge vehicle big red motor big crimson motor... and so on. I am sure it is possible in an SQL statement as I'd like to avoid PL/SQL if possible but I am thinking now that a function/pipelined function might be my only way. Any ideas or solutions gratefully appreciated -- -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en --- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.