Develop and administer Oracle databases and apps. Learn SQL and PL/SQL, indexing, performance tuning, partitions, RAC, backups, Data Guard, security, and APEX. Get deployment tips and automation scripts for stable, compliant environments.
384 posts203 contributors
Very often, we face the problem of how to import data from files to the database. PL/SQL provides an interesting solution: external tables. In this video, we will learn all about external tables.
Using a partition allows you to divide a large table into smaller portions. This allows us to speed up the execution of many queries. And this is what this lesson will be about.
Oracle is one of the most popular RDBMS (Relational Database Management System). PL/SQL (Procedural Language for SQL) is Oracle procedural extension for SQL. In this tutorial, you will learn the basics of PL/SQL in a few dozen minutes.
In this video, I have explained the process of downloading virtual-box software from Oracle's site and then we will go into its installation process. After installation, we will create a Virtual Machine and will look into the configuration of that newly created VM like Virtual Hard Drive.
