... (diesmal in SQL)
SQL>select decode
(sign (floor (maxwidth/2) - rownum)
,1, lpad (' ', floor (maxwidth/2) - (rownum -1))
||rpad ('*', 2 * (rownum -1), ' *')
,lpad ('* * *', floor (maxwidth/2) 3)) "Wir wuenschen frohe Festtage!"
from all_objects
, (select 40 as maxwidth from dual)
where rownum < floor (maxwidth/2) 5
union all
select ' Ihr Pragmatis Team ' from dual;
;
Wir wuenschen frohe Festtage!
--------------------------------------------------------------------------------
*
* *
* * *
* * * *
* * * * *
* * * * * *
* * * * * * *
* * * * * * * *
* * * * * * * * *
* * * * * * * * * *
* * * * * * * * * * *
* * * * * * * * * * * *
* * * * * * * * * * * * *
* * * * * * * * * * * * * *
* * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * *
* * *
* * *
* * *
* * *
* * *
Ihr Pragmatis Team
24 rows selected
(sign (floor (maxwidth/2) - rownum)
,1, lpad (' ', floor (maxwidth/2) - (rownum -1))
||rpad ('*', 2 * (rownum -1), ' *')
,lpad ('* * *', floor (maxwidth/2) 3)) "Wir wuenschen frohe Festtage!"
from all_objects
, (select 40 as maxwidth from dual)
where rownum < floor (maxwidth/2) 5
union all
select ' Ihr Pragmatis Team ' from dual;
;
Wir wuenschen frohe Festtage!
--------------------------------------------------------------------------------
*
* *
* * *
* * * *
* * * * *
* * * * * *
* * * * * * *
* * * * * * * *
* * * * * * * * *
* * * * * * * * * *
* * * * * * * * * * *
* * * * * * * * * * * *
* * * * * * * * * * * * *
* * * * * * * * * * * * * *
* * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * *
* * *
* * *
* * *
* * *
* * *
Ihr Pragmatis Team
24 rows selected
(#Weihnachtliches SQL)