Home » SQL & PL/SQL » SQL & PL/SQL » how to write PL/SQL for permutation..?
how to write PL/SQL for permutation..? [message #245319] Fri, 15 June 2007 22:31 Go to next message
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
hi freiwnd how to write PL/SQL for permutation.
like if a word PAN can be permutated in 6 different words.
Re: how to write PL/SQL for permutation..? [message #245321 is a reply to message #245319] Fri, 15 June 2007 22:39 Go to previous messageGo to next message
Messages: 25570
Registered: January 2009
Location: SoCal
Senior Member
Please read & post as described in STICKY posts at top of this forum.
You seem to know what the output should be.
Break the string into seperate letters & write some nested loops.

[Updated on: Fri, 15 June 2007 22:52] by Moderator

Report message to a moderator

Re: how to write PL/SQL for permutation..? [message #245333 is a reply to message #245319] Sat, 16 June 2007 01:21 Go to previous message
Michel Cadot
Messages: 65138
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
We don't do your homework for you.
Post what you already tried and why you are stuck and we'll help you.


Please always post your Oracle version (4 decimals).
Please read and follow How to format your posts and How to get a quick answer to your question: TIPS AND TRICKS
Previous Topic: Cursors
Next Topic: Alternate way other then UNION command
Goto Forum:

Current Time: Fri Aug 18 00:12:27 CDT 2017

Total time taken to generate the page: 0.05220 seconds