SSI SELAE

Oracle, Programación

RANK() y DENSE_RANK()

by  • 

Como nunca me acuerdo de la diferencia entre RANK() y DENSE_RANK(), me pongo este ejemplo para ver la diferencia: WITH employees AS (SELECT 10 AS department_id, ‘APELLIDO1’ AS last_name, 12 AS salary FROM dual UNION SELECT 10 AS department_id, ‘APELLIDO2’ AS last_name, 12 AS salary FROM dual UNION SELECT 10 AS department_id, ‘APELLIDO3’ AS last_name,…

Read more →

Enlaces, javascript, Programación

Regular expressions 101 — an online regex tester for javascript, php, pcre and python.

by  • 

http://regex101.com/ Regex101.com Regex101.com is a free of charge regex testing service where you can easily create expressions while you simultaneously have real time error detection, highlighting and explanation of your regex. Thanks to the permalink feature, it is a great reference which may even be used in code where you need to explain your regular…

Read more →

Oracle

How to troubleshoot Oracle remote database connection | DaDBm

by  •  • 0 Comments

How to troubleshoot Oracle remote database connection | DaDBm. Buen artículo donde se verifica paso a paso si hay conectividad a una BD Oracle: Ping a la IP Ping al hostname telnet al puerto tnsping formato EZCONNECT hostname:puerto/SID tnsping formato entrada TNSNAMES sqlplus formato EZCONNECT sqlplus user@’//hostname:puerto/SID’ sqlplus formato entrada TNSNAMES  

Read more →

BI, Desarrollo Web

Pentaho: Links

by  •  • 0 Comments

Inteligencia de Negocio y Pentaho: Recursos Alrededor de Pentaho. Comuniity Edition (CE), es decir, Free:  http://community.pentaho.com/ Comparativa con QlikView: http://www.buyto.es/general-business-intelligence/comparativa-y-diferencias-entre-pentaho-y-qlikview Cursos: http://www.stratebi.com/cursos/pentaho DEMO Pentaho + Webdetails: http://demo.webdetails.org:8080/pentaho/content/pentaho-cdf-dd/Render?solution=ClearWireless&path=&file=maindashboard.wcdf Autor de libros sobre Pentaho: http://tgx-hefesto.blogspot.com.es/    

Read more →