Learning path Recently I have started a Data System Specialisation. This includes the core concept in databases and data systems that are applied in practice today. This is a live updated document which I will update as I go through the material. Core Database Concepts Course 1 was all about Core Database concepts, I& expose…
Oracle released a few days ago the new 18c XE (Express Edition), a free version of its popular now upgraded database.
In this implementation we use Oracle to manage files on the server file system and transfer them to a designated network shared location.
Instead of manually compiling procedures, functions, packages and triggers, it’s possible to compile the entire schema by using Oracle’s built in utility.
Sometimes we need to get the DDL of a database object using sqlplus. There are a few things to have in mind.
Useful to determine the database version and if you have APEX (Application Express) and/or Java Virtual Machine (JVM) installed.
Series of actions to determine database state