SQL> with a as
2 (select rownum p from dual connect by level <=21)
3 select
4 7+ ceil (
5 ( 7+ ceil (
6 ( 7+ ceil(p/3))
7 /3))
8 /3)
9 from a;
7+CEIL((7+CEIL((7+CEIL(P/3))/3))/3)
-----------------------------------
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
11
已选择21行。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22664653/viewspace-668419/ ,如需转载,请注明出处,否则将追究法律责任。