Great design: Go to parrent topic link.

SyBooks got some great design insight for hierarchical documentation. All greatness comes from “Go to parent topic” link placed at the end of the document. It’s just easy to click that link when you’ve read or skimmed the whole topic. “Current location” navigation element placed at the top of the page looses that easiness cause […]

Custom listagg function using cursor to bypass ORA-01489

When using build-in listagg function one should always consider that resulting string must have a length less or equal to 4000 characters. If does exceed then an error ‘SQL Error: ORA-01489: result of string concatenation is too long’ is thrown.Here’s a package implementing a custom aggregate function that bypasses this restriction. create or replace PACKAGE […]