Oracle 18c XE released

Oracle released a few days ago the new 18c XE (Express Edition), a free version of its popular now upgraded database.

Transfer local files to network share

In this implementation we use Oracle to manage files on the server file system and transfer them to a designated network shared location.

How to compile all database objects?

Instead of manually compiling procedures, functions, packages and triggers, it’s possible to compile the entire schema by using Oracle’s built in utility.