Merry Xmas & Happy New Year

Merry Xmas and Happy New Year

It’s Christmas time, so I took the liberty to decorate a virtual tree for all DBAs.
Best wishes of Merry Xmas and Happy New Year to everybody.
Of course, each to his own slang 😉

Oracle

SQL> set lines 132 pages 60 trims on feed off head off
SQL> SELECT RPAD(' ', 20, ' ')||'X<<<' FROM  dual
  2  UNION ALL
  3  SELECT RPAD(' ', 20, ' ')||'*' FROM  dual
  4  UNION ALL
  5  SELECT LPAD(SUBSTR(RPAD('*', 20, '*'), 1, level * 2), 20, ' ') ||
  6         '|' ||
  7         RPAD(SUBSTR(RPAD('*', 20, '*'), 1, level * 2), 20, ' ')
  8  FROM  dual
  9  CONNECT BY LEVEL <= 10;

                    X<<<
                    *
                  **|**
                ****|****
              ******|******
            ********|********
          **********|**********
        ************|************
      **************|**************
    ****************|****************
  ******************|******************
********************|********************
SQL>

MySQL

mysql> SELECT CONCAT(REPEAT(' ', 20),'X<<<') as xmas_tree
    -> UNION ALL
    -> SELECT CONCAT(REPEAT(' ', 20),'*')
    -> UNION ALL
    -> SELECT CONCAT(LPAD(SUBSTR(REPEAT('*', 20), 1, @n := @n + 1), 20, ' '),
    ->               '|',
    ->               RPAD(SUBSTR(REPEAT('*', 20), 1, @n), 20, ' '))
    -> FROM   `information_schema`.`tables`,
    ->        (SELECT @n := 0) t
    -> LIMIT 22;
+-------------------------------------------+
| xmas_tree                                 |
+-------------------------------------------+
|                     X<<<                  |
|                     *                     |
|                    *|*                    |
|                   **|**                   |
|                  ***|***                  |
|                 ****|****                 |
|                *****|*****                |
|               ******|******               |
|              *******|*******              |
|             ********|********             |
|            *********|*********            |
|           **********|**********           |
|          ***********|***********          |
|         ************|************         |
|        *************|*************        |
|       **************|**************       |
|      ***************|***************      |
|     ****************|****************     |
|    *****************|*****************    |
|   ******************|******************   |
|  *******************|*******************  |
| ********************|******************** |
+-------------------------------------------+
22 rows in set (0.01 sec)

mysql>

SQLServer

1> SELECT CONVERT(VARCHAR(45), REPLICATE(' ', 20) + 'X<<<')
2> UNION ALL
3> SELECT CONVERT(VARCHAR(45),
4>                REPLICATE(' ', a + b)
5>              + REPLICATE('*', 20 - (a + b)) + '|'
6>              + REPLICATE('*', 20 - (a + b)))
7> FROM (VALUES (5),(4),(3),(2),(1)) x(a)
8> CROSS JOIN (VALUES (15),(10),(5),(0)) y(b);
9> GO

---------------------------------------------
                    X<<<
                    |
                   *|*
                  **|**
                 ***|***
                ****|****
               *****|*****
              ******|******
             *******|*******
            ********|********
           *********|*********
          **********|**********
         ***********|***********
        ************|************
       *************|*************
      **************|**************
     ***************|***************
    ****************|****************
   *****************|*****************
  ******************|******************
 *******************|*******************

(21 rows affected)
1>

© Oracleâ„¢ and MySQLâ„¢ are trade marks of Oracle Corporationâ„¢ (“Oracle”)
© Microsoft SQLServerâ„¢ (“SQLServer”) is a trade mark of Microsoft Corporationâ„¢ (“Microsoft”)

dicembre 22, 2016

Tag:, ,
  • Pingback: sildenafil cost
  • Pingback: live demo viagra
  • Pingback: fildena vs viagra
  • Pingback: viagra boner porn
  • Pingback: sildenafil 50 mg
  • Pingback: viagra generico
  • Pingback: viagra for women
  • Pingback: tadalafil dosage
  • Pingback: viagra accident
  • Pingback: viagra canada
  • Pingback: 100mg viagra
  • Pingback: sildenafil 50mg
  • Pingback: viagra discount
  • Pingback: viagra reviews
  • Pingback: viagra vs levitra
  • Pingback: viagra porn
  • Pingback: viagra sample pack
  • Pingback: viagra for sale
  • Pingback: marley drug viagra
  • Pingback: too much viagra
  • Pingback: sildenafil troche
  • Pingback: cialis indian
  • Pingback: cialis double dose
  • Pingback: sildenafil usa
  • Pingback: Zakhar Berkut hd
  • Pingback: 4569987
  • Pingback: news news news
  • Pingback: online daily
  • Pingback: psy
  • Pingback: psy2022
  • Pingback: projectio-freid
  • Pingback: kinoteatrzarya.ru
  • Pingback: topvideos
  • Pingback: video
  • Pingback: Ukrainskie-serialy
  • Pingback: site
  • Pingback: top
  • Pingback: canadian cialis
  • Pingback: sildenafil dose
  • Pingback: cialis pills 20mg
  • Pingback: generic for viagra
  • Pingback: sildenafil sandoz
  • Pingback: chelovek-iz-90-h
  • Pingback: podolsk-region.ru
  • Pingback: bender na4alo 2021
  • Pingback: blogery_i_dorogi
  • Pingback: chernaya vodova
  • Pingback: 66181
  • Pingback: Porno
  • Pingback: vechernyy urgant
  • Pingback: ukraine
  • Pingback: A3ixW7AS
  • Pingback: link
  • Pingback: KremlinTeam
  • Pingback: medunitsa.ru
  • Pingback: kremlin-team.ru
  • Pingback: psychophysics.ru
  • Pingback: Suicide Squad 2
  • Pingback: psiholog
  • Pingback: cap stromectol
  • Pingback: cialis best price
  • Pingback: buy cialis now
  • Pingback: Duna 2021
  • Pingback: viagra sale tesco
  • Pingback: viagra buy spain
  • Pingback: viagra sale dc
  • Pingback: online ed meds
  • Pingback: cleantalkorg2.ru
  • Pingback: meritking
  • Pingback: elexusbet
  • Pingback: eurocasino
  • Pingback: madridbet
  • Pingback: meritroyalbet
  • Pingback: eurocasino
  • Pingback: eurocasino
  • Pingback: aabbx.store
  • Pingback: meritroyalbet
  • Pingback: ne-smotrite-naverx
  • Pingback: best viagra pills
  • Pingback: arrogant
  • Pingback: Dead-Inside
  • Pingback: 5mg cialis daily
  • Pingback: meritroyalbet
  • Pingback: madridbet
  • Pingback: meritking
  • Pingback: ivermectin 3 mg
  • Pingback: trcasino
  • Pingback: tadalafil online
  • Pingback: elexusbet
  • Pingback: tombala siteleri
  • Pingback: tombala siteleri
  • Pingback: flccc ivermectin
  • Pingback: meritroyalbet
  • Pingback: i-mask
  • Pingback: ivermectin uk
  • Pingback: stromectol uk
  • Pingback: ivermectin 15 mg
  • Pingback: 3rpUI4X
  • Pingback: uliocx
  • Pingback: 34tfA26
  • Pingback: 3J6w3bD
  • Pingback: 3GrvxDp
  • Pingback: 3rrZhf7
  • Pingback: 3L1poB8
  • Pingback: my-vse-mertvy-2022
  • Pingback: stromectol price
  • Pingback: ivermectin buy uk
  • Pingback: order viagra
  • Pingback: dexis ivermectin
  • Pingback: cialis 20 mg
  • Pingback: sildenafil tablets
  • Pingback: cialis wirkung
  • Pingback: sildenafil pills
  • Pingback: cheap tadalafil
  • Pingback: tadalafil sale
  • Pingback: 1specialist
  • Pingback: 1prototype
  • Pingback: buy generic cialis
  • Pingback: meritroyalbet
  • Pingback: que es viagra
  • Pingback: what is cialis
  • Pingback: cialis tadalafil
  • Pingback: stromectol uk buy
  • Pingback: cialis 20mg online
  • Pingback: buy viagra online
  • Pingback: ivermectin buy
  • Pingback: z.globus-kino.ru
  • Pingback: cialis price
  • Pingback: meritking
  • Pingback: lasix 12
  • Pingback: meritking
  • Pingback: eurocasino
  • Pingback: eurocasino
  • Pingback: ivermectine mylan
  • Pingback: covid ivermectin
  • Pingback: yutub
  • Pingback: nih ivermectin
  • Pingback: madridbet
  • Pingback: ivermectine
  • Pingback: ivermectina piojos
  • Pingback: WordPress
  • Pingback: child porn
  • Pingback: filmfilmfilmes
  • Pingback: gRh9UPV
  • Pingback: 9-05-2022
  • Pingback: TopGun2022
  • Pingback: Xvideos
  • Pingback: XVIDEOSCOM Videos
  • Pingback: ivanesva
  • Pingback: tadalafil sale
  • Pingback: sudocrem
  • Pingback: Netflix
  • Pingback: FILM
  • Pingback: designchita.ru
  • Pingback: YA-krasneyu
  • Pingback: design-human.ru
  • Pingback: designmsu.ru
  • Pingback: vkl-design.ru
  • Pingback: irida-design.ru
  • Pingback: psy online
  • Pingback: uels ukrain
  • Pingback: Buy This Domain
  • Pingback: ivermectin nz
  • Pingback: bahis siteleri
  • Pingback: fishscale cocaine
  • Pingback: fish scale coke
  • Pingback: buy 5-meo-dmt usa
  • Pingback: DPTPtNqS
  • Pingback: qQ8KZZE6
  • Pingback: D6tuzANh
  • Pingback: SHKALA TONOV
  • Pingback: classic books
  • Pingback: 3Hk12Bl
  • Pingback: 3NOZC44
  • Pingback: 01211
  • Pingback: tor-lyubov-i-grom
  • Pingback: film-tor-2022
  • Pingback: hd-tor-2022
  • Pingback: hdorg2.ru
  • Pingback: trade show models
  • Pingback: Promotional models
  • Pingback: Psikholog
  • Pingback: netstate.ru
  • Pingback: mango juul pods
  • Pingback: Buy This Domain
  • Pingback: pgslot
  • Pingback: Best HP Printers
  • Pingback: Hp Laptops
  • Pingback: stromectol humans
  • Pingback: bit.ly
  • Pingback: vintage posters
  • Pingback: russian bookstore
  • Pingback: bucha killings
  • Pingback: War in Ukraine
  • Pingback: buy weed in dubai
  • Pingback: concerta for sale
  • Pingback: stats
  • Pingback: slayer sneakers
  • Pingback: slayer sneakers
  • Pingback: slayer sneakers
  • Pingback: poceros elda
  • Pingback: desatascos elda
  • Pingback: Ukraine-war
  • Pingback: movies
  • Pingback: gidonline
  • Pingback: w320axgf-9-bxr3-r2
  • Pingback: stromectol 6mg
  • Pingback: joker slot 123
  • Pingback: tiles lowes
  • Pingback: bathroom tile
  • Pingback: maui tile
  • Pingback: Cocaine for Sale
  • Pingback: Dmt Pen
  • Pingback: Buy Dmt
  • Pingback: Buy 5 Meo Dmt
  • Pingback: 4-Aco-Dmt
  • Pingback: Wikipedia
  • Pingback: web
  • Pingback: ssono
  • Pingback: film.8filmov.ru
  • Pingback: hidrafaciales
  • Pingback: crime news
  • Pingback: India news
  • Pingback: Trending news
  • Pingback: Technology news
  • Pingback: Consumer
  • Pingback: how cialis works
  • Pingback: forex community
  • Pingback: Forex articles
  • Pingback: Forex Education
  • Pingback: 3d model archive
  • Pingback: مياة
  • Pingback: Anonimo
  • Pingback: Sports news
  • Pingback: Business news
  • Pingback: Business news
  • Pingback: filmgoda.ru
  • Pingback: rodnoe-kino-ru
  • Pingback: stat.netstate.ru
  • Pingback: Best IPTV Service
  • Pingback: Best IPTV Service
  • Pingback: you can look here
  • Pingback: look what i found
  • Pingback: explanation
  • Pingback: see this page
  • Pingback: sY5am
  • Pingback: liquor prices
  • Pingback: Surveillance
  • Pingback: Surveillance
  • Pingback: Dom drakona
  • Pingback: JGXldbkj
  • Pingback: aOuSjapt
  • Pingback: psikholog moskva
  • Pingback: A片
  • Pingback: Repze LLC
  • Pingback: Repze LLC
  • Pingback: Repze LLC
  • Pingback: Dim Drakona 2022
  • Pingback: TwnE4zl6
  • Pingback: psy 3CtwvjS
  • Pingback: مسيار
  • Pingback: lalochesia
  • Pingback: film onlinee
  • Pingback: wmbet
  • Pingback: buy focalin online
  • Pingback: sbobet
  • Pingback: 3qAIwwN
  • Pingback: video-2
  • Pingback: study in egypt
  • Pingback: egypt education
  • Pingback: كليات مصر
  • Pingback: sezons.store
  • Pingback: Guns on Sale
  • Pingback: Glock 17 for Sale
  • Pingback: 9mm Ammo
  • Pingback: 45 ACP Ammo
  • Pingback: Colt 1911 for Sale
  • Pingback: spytostyle.com
  • Pingback: spytostyle.com
  • Pingback: SpyToStyle
  • Pingback: SpyToStyle
  • Pingback: SpytoStyle.Com
  • Pingback: SpytoStyle.Com
  • Pingback: SpyToStyle
  • Pingback: psy-news.ru
  • Pingback: bet789
  • Pingback: minecraft lmhmod
  • Pingback: soi cau 247
  • Pingback: sieuno
  • Pingback: Game bài
  • Pingback: stromectol 3mg
  • Pingback: so em xui la gi
  • Pingback: 000-1
  • Pingback: 3SoTS32
  • Pingback: 3DGofO7
  • Pingback: Sangeetas Kitchen
  • Pingback: Sangitha's Kitchen
  • Pingback: 22 Hornet Ammo
  • Pingback: fue
  • Pingback: rftrip.ru
  • Pingback: Men's Dress Shirts
  • Pingback: wristband medical
  • Pingback: curly girl method
  • Pingback: dolpsy.ru
  • Pingback: 3-AXIS MACHINING
  • Pingback: kin0shki.ru
  • Pingback: 3o9cpydyue4s8.ru
  • Pingback: mb588.ru
  • Pingback: newsukraine.ru
  • Pingback: click here
  • Pingback: fireman songs
  • Pingback: fue
  • Pingback: edu-design.ru
  • Pingback: tftl.ru
  • Pingback: brutv
  • Pingback: FUE
  • Pingback: Future University
  • Pingback: site 2023
  • Pingback: Mushrooms For Sale
  • Pingback: packages to Serbia
  • Pingback: Al Arabiya News
  • Pingback: GLOCK 43
  • Pingback: Armalite AR10
  • Pingback: GLOCK 43X
  • Pingback: Cousin Pat
  • Pingback: FUE
  • Pingback: FUE
  • Pingback: Future University
  • Pingback: sitestats01
  • Pingback: 1c789.ru
  • Pingback: cttdu.ru
  • Pingback: Health Guide
  • Pingback: Healthcare tips
  • Pingback: curly hair
  • Pingback: 1703
  • Pingback: hdserial2023.ru
  • Pingback: serialhd2023.ru
  • Pingback: Healthcare tips
  • Pingback: matchonline2022.ru
  • Pingback: kamagra online
  • Pingback: FUE
  • Pingback: Future University
  • Pingback: jeremiah robles
  • Pingback: bit.ly/3OEzOZR
  • Pingback: bit.ly/3gGFqGq
  • Pingback: vidalista 5
  • Pingback: bit.ly/3ARFdXA
  • Pingback: bit.ly/3ig2UT5
  • Pingback: bit.ly/3GQNK0J
  • Pingback: grandpashabet
  • Pingback: bep5w0Df
  • Lascia un commento