Search results
08/29/2014
Video tutorial
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.
08/25/2014
Video tutorial
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.
07/30/2014
Video tutorial
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.
06/04/2014
Video tutorial
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.
05/26/2014
Video tutorial
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.
05/14/2014
Video tutorial
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.
04/29/2014
Video tutorial
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.
04/29/2014
Video tutorial
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.
03/27/2014
Video tutorial
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.
12/23/2013
Video tutorial
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.