martedì 15 maggio 2018

Raspberry Pi: Boot Manager

Noobs
https://www.raspberrypi.org/downloads/noobs/

BerryBoot
https://www.berryterminal.com/doku.php/berryboot

Pinn
https://sourceforge.net/projects/pinn/files/pinn-lite.zip/download
http://noobs.matthuisman.nz (Custom System Size)

sabato 12 maggio 2018

Raspberry Pi: Ubuntu Mate

sudo service NetworkManager restart

venerdì 11 maggio 2018

SQL ORACLE: LEAD

SELECT last_name, hire_date, LEAD(hire_date, 1) OVER (ORDER BY hire_date) AS "NextHired" FROM employees WHERE department_id = 30; LAST_NAME HIRE_DATE NextHired ------------------------- --------- --------- Raphaely 07-DEC-94 18-MAY-95 Khoo 18-MAY-95 24-JUL-97 Tobias 24-JUL-97 24-DEC-97 Baida 24-DEC-97 15-NOV-98 Himuro 15-NOV-98 10-AUG-99 Colmenares 10-AUG-99

martedì 13 marzo 2018

How to convert milliseconds to date string in Oracle SQL

select to_char(to_date('1970-01-01 00','yyyy-mm-dd hh24') + (1517356800000)/1000/60/60/24 , 'YYYY-MM-DD HH24:MI:SS') datestr from dual;

venerdì 2 marzo 2018

lunedì 18 dicembre 2017

SQL ORACLE: Trasformare stringa in tabella

SELECT Replace(CAMPO,'''','') CAMPO FROM ( SELECT * FROM dual PIVOT ( COUNT(*) FOR (DUMMY) IN ( 'CNR1','321G','321H','321I' ))) mytab UNPIVOT INCLUDE NULLS ( VAL FOR( CAMPO ) IN ( "'CNR1'","'321G'","'321H'","'321I'" ) );