Database Links - Oracle PL SQL Course - Lesson 40
This video discuss the details demanded to setup the environment to establish a remote connect to a database server, which can be another Oracle instance or any other database that has an ODBC driver.
The SQL*Loader - Oracle PL SQL Course - Lesson 39
Importing files with textual data in CSV format into the Oracle is performed by utility called SQL*Loader. This video shows how to work with these files using the import control files of SQL*Loader by using examples.
Importing and exporting data - Oracle PL SQL Course - Lesson 38
Oracle has many tools and utilities to perform the import and export data into and from a database. This video shows how to use the IMP and EXP command line utilities to import and export, respectively, data to and from Oracle tables.
Managing dependencies - Oracle PL SQL Course - Lesson 35
This video explain the scenarios and situations where object dependency is an issue in Oracle and provide some examples that show how an object can be invalid because of a broken chain on dependency.
Table Statistics - Oracle PL SQL Course - Lesson 31
This video explain how are statistics and histograms and how why they are important. The examples show how to gather the statistics using the ANALYZE command and check the blocks size allocation in the DBA_TABLES and the DBA_INDEXES views.
Triggers - Oracle PL SQL Course - Lesson 28
This video explain the trigger concept and show the details of timming, event, type, when clause, firing sequence, :NEW and :OLD qualifiers, and the internal DELETING, INSERTING and UPDATING variables.
Creating Functions - Oracle PL SQL Course - Lesson 24
This video will discuss the details about the creation of functions in Oracle: the differences from procedures, the type of return values, what can and cannot be inside a function, the parameters types and how to execute the functions.
Creating procedures - Oracle PL SQL Course - Lesson 23
This video discuss about the following advantages of procedures in Oracle: modularity, reusability, extensibility, maintainability, data security, integrity, improved performance and code clarity.
Control Structures - Oracle PL SQL Course - Lesson 19
This video shows how to use the IF, ELSE, ELSEIF, CASE, LOOP, WHILE and FOR statements inside a PL/SQL block by explaining the purpose, the syntax and how these commands can be used in very simple examples.
Declaring Variables - Oracle PL SQL Course - Lesson 16
This video explains the concept and components of a PL/SQL and focus on how to work with normal variables created in the DECLARE session. You can also see the two other types of variables that can be used only SQLPlus: host and bind variables.