SQL*Plus and command history in Linux using rlwrap

In the SQL*Plus itself is not possible to browsing history commands (except the last command executed, he can re-create using the “r” + Enter). On Windows, this can be quite well made via a function key F7, as shown in the picture. Elegantly can scroll through the history commands performed. [Česká verze článku – SQL*Plus…

How to recompile invalid objects recursively

About recompiling invalid objects in Oracle database on the Internet, there is certainly lots of scripts. Still, I decided to write my own package, which can skip recompiling addition of objects, which are undesirable in that moment, or compile them for a long time “hangs” (I mean for example, objects that contain links to remote…