Oracle Database Archives - Bufallos from Oracle

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

If you have the need to have the average value of an expression in a query, the right thing is

Have you ever seen yourself in a situation where you end up building a giant query, doing UNIONs with other

You may have already had the need to join / combine the result of two or more queries into the

If you have the need to compare results between two or more queries in the database, there is an ORACLE

If you need to transform a DATE or NUMBER into a STRING, the function that ORACLE provides is TO_CHAR. Much like

Do you know when you are querying the database and need to transform a STRING into a DATA format? Well,

Continuing the ORACLE DATABASE session I will post another quick but functional balcony, which is a query which shows you

Keeping the objective of making the Oracle Database as a repository of information that can help us with our demands,

Hello everyone, I will be registering here in the blog a series of resources that are used in our daily