SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

All possible combinations of String in PL/SQL

535708Oct 9 2006 — edited Aug 10 2011

Hi All,

Could you please explain the logic of getting all possible combinations of String in PL/SQL?
For ex if "HER" is string
then the output should be
HER
HRE
ERH
EHR
REH
RHE

Thanks
Suman

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2011

Added on Oct 9 2006

14 comments

16,548 views

SQL & PL/SQL

All possible combinations of String in PL/SQL

Comments

Post Details