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
ashishmcajec
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.
1.pan
2.pna
3.apn
4.anp
5.npa
6.nap
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
BlackSwan
Messages: 25050
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: 64152
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.

Regards
Michel

P.S.:
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: Sat Dec 10 14:44:28 CST 2016

Total time taken to generate the page: 0.08711 seconds