How to List All Tables in Oracle
In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Tables that You Own… Read More »How to List All Tables in Oracle
Group Functions
How to Resolve Returned String That was Truncated by MySQL
I think you might have used a group function called group_concat() in your SQL statement as I did and saw only 1024 characters returned in the… Read More »How to Resolve Returned String That was Truncated by MySQL
How to Select Rows Contains Maximum Values
You may notice that, when we selected the maximum value (via MAX()) and with other columns, they looked like in the same row, but in fact,… Read More »How to Select Rows Contains Maximum Values