Buon Natale e felice anno nuovo

Buon Natale e felice anno nuovo

Siamo in periodo natalizio, quindi mi sono permesso di addobbare un albero virtuale per tutti i dba.
Concedetemi di augurare “Buon Natale e felice anno nuovo” a tutti voi.
Ovviamente, ad ognuno il suo “dialetto” 😉

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â„¢ e MySQLâ„¢ sono marchi registrati da Oracle Corporationâ„¢ (“Oracle”)
© Microsoft SQLServerâ„¢ (“SQLServer”) è un marchio registrato da Microsoft Corporationâ„¢ (“Microsoft”)

ottobre 9, 2018

Tag:, ,
  • Pingback: sildenafil dosages
  • Pingback: buy generic viagra
  • Pingback: cialis extraforrel
  • Pingback: cialis dapoxetine
  • Pingback: priligy jelly
  • Pingback: priligy for people
  • Pingback: ivermectin dose
  • Pingback: ivermectin clav
  • Pingback: stromectol deutsch
  • Pingback: viagra buy 24
  • Pingback: cialis 5mg online
  • Pingback: male ed pills
  • Pingback: purple viagra 100
  • Pingback: viagra type pills
  • Pingback: best viagra
  • Pingback: cialis daily price
  • Pingback: viagra on sale
  • Pingback: stromectol cream
  • Pingback: can i buy viagra
  • Pingback: flccc ivermectin
  • Pingback: flccc ivermectin
  • Pingback: Anonimo
  • Pingback: flccc ivermectin
  • Pingback: stromectol drug
  • Pingback: ivermectin 400 mg
  • Pingback: stromectol pill
  • Pingback: stromectol tab 3mg
  • Pingback: ivermectin 1mg
  • Pingback: Anonimo
  • Pingback: ivermectin ireland
  • Pingback: ivermectin buy
  • Pingback: ivermectin generic
  • Pingback: cheap tadalafil
  • Pingback: ivermectin syrup
  • Pingback: sildenafil india
  • Pingback: cialis cost
  • Pingback: kamagra online
  • Pingback: sildenafil tablets
  • Pingback: cialis best price
  • Pingback: corona pills
  • Pingback: 3venomous
  • Pingback: 2everyday
  • Pingback: generic tadalafil
  • Pingback: meritking
  • Pingback: meritroyalbet
  • Pingback: meritrroyalbet
  • Pingback: meritroyalbet
  • Pingback: eurocasino
  • Pingback: child porn
  • Pingback: meritking
  • Pingback: child porn
  • Pingback: elexusbet
  • Pingback: borgata casino
  • Pingback: generic cialis
  • Pingback: cefdinir use
  • Pingback: cialis tadalafil
  • Pingback: cialis online
  • Pingback: ciprofloxacin dogs
  • Pingback: ivermectin gel
  • Pingback: ivermectin 0.5
  • Pingback: azithromycin 100mg
  • Pingback: ciprofloxacin med
  • Pingback: ivermectin 2
  • Pingback: clindamycin dosage
  • Pingback: duricef
  • Pingback: meritroyalbet
  • Pingback: meritking
  • Pingback: meritking
  • Pingback: trcasino
  • Pingback: peptides tadalafil
  • Pingback: eurocasino
  • Pingback: madridbet
  • Pingback: playluckylands
  • Pingback: ivermectin 4000
  • Pingback: ivermectin generic
  • Pingback: madritbet
  • Pingback: meritroyalbet
  • Pingback: eurocasino
  • Pingback: elexusbet
  • Pingback: stromectol liquid
  • Pingback: ivermectin humans
  • Pingback: stromectol oral
  • Pingback: mylan tadalafil
  • Pingback: bahis siteleri
  • Pingback: stromectol preis
  • Pingback: stromectol 3mg
  • Pingback: viagra
  • Pingback: revatio
  • Pingback: A片
  • Pingback: buy stromectol 3mg
  • Pingback: Grandpashabet
  • Pingback: grandpashabet
  • Lascia un commento