How to List All Tables in Oracleby Ed ChenAugust 23, 2018June 14, 20222 CommentsIn 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
How to Resolve Returned String That was Truncated by MySQLby Ed ChenJanuary 8, 2016August 1, 2021I 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 Valuesby Ed ChenOctober 16, 2015March 29, 2018You 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