Link Sourcetree to your GitHub account

One of the most popular places to store and share your code online is GitHub. And one of the best free desktop Version control tools is without any doubt Sourcetree. Having all the good feature, of using them both, in mind, there are still some moments that can ruin your experience, especially when you are … Continue reading Link Sourcetree to your GitHub account

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