marcoandolfi.blogspot.com
Marco Andolfi's Blog: settembre 2014
http://marcoandolfi.blogspot.com/2014_09_01_archive.html
This is simply a blog containing small code snippets I found useful during my work! Lunedì 29 settembre 2014. Extract DB as XML. I want to have a single query which is extracting the complete structure of the database into a simple XML. I want to have as output:. Xml version="1.0" encoding="UTF-8"? And here is the query to do it:. As xml tag from dual union all select 'CLOSETAG' as tagtype, ' 9999' as postfix, ' /? Schema name="' username '"') else replace(xml builder.xml tag, '? Giovedì 25 settembre 2014.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: giugno 2014
http://marcoandolfi.blogspot.com/2014_06_01_archive.html
This is simply a blog containing small code snippets I found useful during my work! Domenica 29 giugno 2014. Top 10 Stupid code. In my job, I have the opportunity of watching how people think. I believe that a piece of code is a great demonstration about the cognitive skills of a person. The question of the picture above says a lot. BeastUK "problem solving" skills are quite limited. During my profession, I have to instruct developers about what is needed to do and review also their code. Select a from m...
marcoandolfi.blogspot.com
Marco Andolfi's Blog: Oracle:Linear regression through a SQL Query
http://marcoandolfi.blogspot.com/2015/08/oracle-sql-for-getting-linear.html
This is simply a blog containing small code snippets I found useful during my work! Lunedì 10 agosto 2015. Oracle:Linear regression through a SQL Query. I want to have a linear approximation directly in an SQL query. To make it easy: having a generic function f, I want to approximate it with the function:. Being sure that I found the A and B which minimize the global error between f and f' (where f' is the linear approximation of f). Let's generate some data:. This query generate the following output:.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: Tutorial: neural network in R by examples (using the package neuralnet)
http://marcoandolfi.blogspot.com/2015/08/tutorial-neural-network-in-r-by.html
This is simply a blog containing small code snippets I found useful during my work! Venerdì 7 agosto 2015. Tutorial: neural network in R by examples (using the package neuralnet). Tutorial: Create a neural network in R. Let's start with the basics. If you want to start learning how does it work a NN in R, start searching for some packages supporting you. Googling a bit you will wee that there are two main packages:. Neuralnet: specific for neural networks. Basic AND and OR functions. Summary(net) Length ...
marcoandolfi.blogspot.com
Marco Andolfi's Blog: aprile 2014
http://marcoandolfi.blogspot.com/2014_04_01_archive.html
This is simply a blog containing small code snippets I found useful during my work! Domenica 27 aprile 2014. Basic SQL Operation in R. I want to have in R the equivalent of most of the basic operations normally performed in SQL. In this post it will follow a sniplet in SQL and immediately after the correspondent in R. Inner / outer joins. Source: http:/ code.google.com/p/sqldf/. SELECT * FROM df1 WHERE product = "Toaster". The select distinct in SQL:. Select distinct x from my table;. INNER / OUTER JOINS.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: Oracle: SQL for list of numbers or list of dates
http://marcoandolfi.blogspot.com/2015/06/oracle-sql-for-list-of-numbers-or-list.html
This is simply a blog containing small code snippets I found useful during my work! Giovedì 18 giugno 2015. Oracle: SQL for list of numbers or list of dates. I want to have a query which returns the list of the dates from today, for the next 10 years:. SELECT level seq, starting. Level as ddate,. FROM DUAL CONNECT BY LEVEL =. The "parameters" needed by this query are:. Starting: the value where to start. Delta: the number of days between each occurrence of the list. For example, given the following query:.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: luglio 2014
http://marcoandolfi.blogspot.com/2014_07_01_archive.html
This is simply a blog containing small code snippets I found useful during my work! Martedì 29 luglio 2014. You get stuck in your dozens daily problems. You do not know how to get out of it. This is the exact meaning of "Thinking outside the box": try to see your problem from a different angle. How can you? Do not hold your problems strict in your hands. try to now look at them and come back later. The angle will be for sure different! Domenica 27 luglio 2014. Mercoledì 16 luglio 2014.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: Improvement philosophy
http://marcoandolfi.blogspot.com/2014/11/improvement-philosophy.html
This is simply a blog containing small code snippets I found useful during my work! Venerdì 7 novembre 2014. Next time think twice about what are you doing. are you sure that you cannot stop for a second? Iscriviti a: Commenti sul post (Atom). Visualizza il mio profilo completo. Sankey Diagram with D3JS. Modello Fantastico S.p.A. Powered by Blogger.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: giugno 2015
http://marcoandolfi.blogspot.com/2015_06_01_archive.html
This is simply a blog containing small code snippets I found useful during my work! Giovedì 18 giugno 2015. Oracle: SQL for list of numbers or list of dates. I want to have a query which returns the list of the dates from today, for the next 10 years:. SELECT level seq, starting. Level as ddate,. FROM DUAL CONNECT BY LEVEL =. The "parameters" needed by this query are:. Starting: the value where to start. Delta: the number of days between each occurrence of the list. For example, given the following query:.
marcoandolfi.blogspot.com
Marco Andolfi's Blog: agosto 2015
http://marcoandolfi.blogspot.com/2015_08_01_archive.html
This is simply a blog containing small code snippets I found useful during my work! Lunedì 10 agosto 2015. Oracle:Linear regression through a SQL Query. I want to have a linear approximation directly in an SQL query. To make it easy: having a generic function f, I want to approximate it with the function:. Being sure that I found the A and B which minimize the global error between f and f' (where f' is the linear approximation of f). Let's generate some data:. This query generate the following output:.
