Oracle 12.1, ORA-01489 result of string concatenation is too long

Listagg is a great way to concatenate strings in Oracle 12. I have used it in many cases, but sometimes it is just not good enough for a very large strings. Here is the way you can use it for strings, that would not exceed 4000 chars: SELECT FNR, ATTEST_DATO, STATUS, TYPE_FORMAAL, LISTAGG(INNHOLD,  CHR(13)||CHR(10) ) … Continue reading Oracle 12.1, ORA-01489 result of string concatenation is too long

Oracle 12.1, ORA-00942: table or view does not exist

This is a bug in Oracle 12.1. When you have a table in one schema (Schema1) with a sequence on some column and you want to insert in that table from another schema (Schema2), error message "ORA-00942: table or view does not exist" is displayed. This happens although you have privileges to select, insert, update … Continue reading Oracle 12.1, ORA-00942: table or view does not exist