Laurent Schneider

Anagram Help - Oracle9i Enterprise …

I just posted a solution on the OTN forums where I am using a regular table function and a recursive procedure to generate anagrams

select * from table(anagram.f('ABC'));

COLUMN_VALUE
------------
ABC
ACB
BAC
BCA
CAB
CBA

This entry was posted on Tuesday, April 17th, 2007 at 13:41 and is filed under oracle, sql. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
Post to : del.icio.us - Digg it - Furl - reddit - Spurl