问题描述
我想我有一个复杂的要求.
I think I have a complex requirement.
这是一个使用 Oracle 10.2 的组合排列,我能够使用笛卡尔连接解决它,但我认为它需要一些改进以使其更简单和更灵活.
It's a combinatorial permutation using Oracle 10.2, I'was able to solve it using cartesian joins, but I think that it need some improvements to made it simplest and more flexible.
主要行为.
输入字符串:'一二'
输出:'一''二''一二'两个一"
output: 'one' 'two' 'one two' 'two one'
对于我的解决方案,我将字符串的数量限制为 5(请注意,输出是阶乘附近的数字)
For my solution I've restricted the number of strings to 5 (note that the output is a number near the factorial)
SQL:
推荐答案
得到了通用的.最后真的很简单(但我花了一段时间才到达那里)
Got the generic one. Really simple in the end (but took me a while to get there)
Edit2:删除了多余的 maxnum 内容.之前尝试的遗留问题
Removed redundant maxnum stuff. Left over from previous attempts
这篇关于Oracle - 字符串组合排列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!