Avoid getting infected by Corona virus disease by following these 7 simple habits : a personal experience






The coronavirus COVID-19 is affecting 213 countries and territories around the world and 2 international conveyances which can be tracked from world corona tracker.





Let's know more about corona virus and how it impacts human body followed by the habits which can prevent us from getting infected by life threatening corona virus disease as "prevention is better than cure"

ORA-01489: result of string concatenation is too long using listagg function oracle


ORA- Error: 


1.
SQL>select listagg(description,',' ) within group (order by description) from mis_report_2020;

select listagg(
description,',' ) within group (order by description) from mis_report_2020

*
ERROR at line 1:
ORA-01489: result of string concatenation is too long





2.
SQL> select listagg(description,',' ON OVERFLOW TRUNCATE) within group (order by description) from mis_report_2020;

select listagg(
description,',' ON OVERFLOW TRUNCATE) within group (order by description)  from mis_report_2020


*
ERROR at line 1:
ORA-00907: missing right parenthesis