I hope this gives you a bit FUN with pg SQL.
select * from (select array_to_string(array_agg(CASE WHEN (power((xx.x-25),2)/130+power((yy.y-25),2)/130)=1 THEN '$' WHEN (sqrt(power(xx.x-20,2)+power(yy.y-20,2)))<2 THEN '#' WHEN (sqrt(power(xx.x-20,2)+power(yy.y-30,2)))<2 THEN '#' WHEN (sqrt(power(xx.x-29,2)+power(yy.y-25,2)))<4 THEN '#' WHEN (power((xx.x-10),2)/40+power((yy.y-10),2)/40)=1 THEN '$' WHEN (power((xx.x-10),2)/40+power((yy.y-40),2)/40=1) THEN '$' ELSE ' ' END),' ') as cartoon from (select generate_series(1,40) as x) as xx,(select generate_series(1,50) as y) as yy group by xx.x order by xx.x) as co_ord;
Oracle Mode
CREATE OR REPLACE TYPE series AS TABLE OF NUMBER; CREATE OR REPLACE FUNCTION generate_series(n INT, m INT) RETURN series PIPELINED IS BEGIN FOR i IN n..m LOOP PIPE ROW (i); END LOOP; RETURN; END; SELECT REPLACE(WM_CONCAT( CASE WHEN (power((xx.COLUMN_VALUE-25),2)/130+power((yy.COLUMN_VALUE-25),2)/130)=1 THEN '$' WHEN (sqrt(power(xx.COLUMN_VALUE-20,2)+power(yy.COLUMN_VALUE-20,2)))<2 THEN '#' WHEN (sqrt(power(xx.COLUMN_VALUE-20,2)+power(yy.COLUMN_VALUE-30,2)))<2 THEN '#' WHEN (sqrt(power(xx.COLUMN_VALUE-29,2)+power(yy.COLUMN_VALUE-25,2)))<4 THEN '#' WHEN (power((xx.COLUMN_VALUE-10),2)/40+power((yy.COLUMN_VALUE-10),2)/40)=1 THEN '$' WHEN (power((xx.COLUMN_VALUE-10),2)/40+power((yy.COLUMN_VALUE-40),2)/40=1) THEN '$' ELSE ' ' END ), ',', ' ') cartoon FROM ( SELECT * FROM TABLE(generate_series(1, 40))) xx, ( SELECT * FROM TABLE(generate_series(1, 50))) yy GROUP BY xx.COLUMN_VALUE ORDER BY xx.COLUMN_VALUE;Dinesh Kumar
It's funny!
ReplyDeleteThank You :)
DeleteVery clever!
ReplyDeleteThanks.
DeleteAs nice as useless.
ReplyDeleteAgreed :)
DeletemorgeAlaza_Atlanta Chase Hicks https://wakelet.com/wake/gCErg2jiuTF_FSd3EXuS-
ReplyDeleterirelingcrem
0subsconrandzo Paul Golonka WonderShare Recoverit
ReplyDeleteNulled
Winamp Pro
dfinedunpo