I once wrote an article about SOA where I described the kind of perfect scenario to use your concept. I
Continue reading »How to limit the number of rows in an ORACLE query?
Once I was doing an integration between two distinct banks: MySQL and PostgreSQL. During work it was very common for
Continue reading »Here’s how to use the Oracle AVG function
If you have the need to have the average value of an expression in a query, the right thing is
Continue reading »How to use the Oracle NVL function
Have you ever seen yourself in a situation where you end up building a giant query, doing UNIONs with other
Continue reading »Discover all the truth about SOA
Every time we think about a business as a corporate environment, composed of several niches in the same environment (HR,
Continue reading »Here’s how to use the UNION and UNION ALL operators.
You may have already had the need to join / combine the result of two or more queries into the
Continue reading »Oracle INTERSECT Operator
If you have the need to compare results between two or more queries in the database, there is an ORACLE
Continue reading »How to use the Oracle MINUS operator
When you work with the database, it is very common for you to have to analyze queries made in the
Continue reading »Function Oracle TO_CHAR
If you need to transform a DATE or NUMBER into a STRING, the function that ORACLE provides is TO_CHAR. Much like
Continue reading »Function Oracle TO_DATE
Do you know when you are querying the database and need to transform a STRING into a DATA format? Well,
Continue reading »