Upon reviewing that blog post, I can see that it solves a very specific problem. So it is probably only marginally applicable. However, I still believe that powermultiset is the function you want.
On Sun, Sep 29, 2013 at 9:07 AM, Michael Moore <michaeljmo...@gmail.com>wrote: > Hi Phil, > This might help. http://plsqlnotes.blogspot.com/search/label/powermultiset. > I'm not 10% sure that it applies, but I think it does. > > Mike > > > > On Sun, Sep 29, 2013 at 3:51 AM, Phil W <philwinfi...@gmail.com> wrote: > >> 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. >> >> 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 option. Does anyone with better SQL than me know how this >> can be done please? >> >> create table word_syn >> (value varchar2(30), >> likeness varchar2(30)) >> / >> >> insert all >> into word_syn values ('red','rouge') >> into word_syn values ('red','crimson') >> into word_syn values ('car','motor') >> into word_syn values ('car','vehicle') >> select 1 from dual >> / >> >> >> /* 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. >> */ >> >> >> -- >> -- >> 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. >> > > -- -- 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.
