UX idea: Advanced highlighting and formatting for code editors and IDEs

It’s 2014 but we still lack intellectual tools that could help us to produce high quality code. As Steve McConnell mentions in his book ‘Code Complete’ naming standards are vital for any software project. It’s good for you if you have established one and if you adhere to a good naming scheme, even better if […]

PL/SQL: Generic function for converting arbitrary cursor to clob (delimited text). Take two

Addressing large dataset issue that was mentioned for previously developed cursor to clob conversion functions (see previous post) a new version of a function that converts any query into delimited text was born.Not so elegant nevertheless it handles nulls (thanks to this StackOverflow topic) and large datasets (that still needs approval).If you fill able, you […]

PL/SQL: Generic function for converting arbitrary cursor to clob (delimited text)

Thanks to a couple of posts (namely TO_CHAR of an Oracle PL/SQL TABLE type and SQL*Plus tips. #2) I was able to develop very convenient and what’s more important generic function for converting arbitrary cursor to clob lines or say any result set to clob lines.Such function will be very useful for unloading results of […]