This Oracle video tutorial explains basic and more advanced aspects of importing and exporting data in Oracle 11g. External tables and ...
PL/SQL Oracle tutorial video
Now, Oracle is one of the most sophisticated database management systems. Up to now, learning tens of tools and hundreds of functions required a lot of time.
Now, you have a choice. You can get familiar with all the unique options it offers in 2 hours or learn one of the database programming techniques you need in just a few minutes.
11 video lessons prepared by an expert will teach you all you need to know about Oracle. You will be able to use all the options offered by Oracle effectively.
What do you prefer? To spend long hours reading a book, or going through tens of lengthy tutorials on the internet just to see how to prepare one script, or to start using tens new tools and functions fast and effectively – all in this one course?
- Save your time. You get instant access to your course from anywhere in the world, and don’t lose time for commuting!
- Save your money. You only pay for the knowledge and not for the packaging and transport.
- Feel the comfort! You learn when and where you want. You decide how fast you want to learn!
Click on Buy Now and the tutorial will be on your hard disk within a few minutes!
- PL/SQL Oracle introduction (22:40)
anonymous block, dbms_output, put_line, declaration section, comments, variables, concatenation operator, data types, to_char, to_number, to_date, type, rowtype, format flags, select into, conditional structures, if then elsif else statement, case when, iterative structures, simple loop, for loop, while loop
- PL/SQL Oracle Cursors (20:40)
oracle cursor, implicit cursor, explicit cursor, rowcount, found, notfound, isopen, open, fetch into, close, cursor for loop, dynamic cursor, cursor for update, where current of, cursor parameters
- Oracle Procedures and Functions (19:00)
create or replace procedure, function, positional notation, named notation, mixed notation, type, rowtype, pass by value parameter, pass by reference, default parameters, return, parameter modes: in, out, in out
- PL/SQL Oracle Exception handling (22:15)
exception block, error handling, named system exceptions, unnamed system exceptions, named programmer-defined exception, unnamed programmer-defined exception, when others, handle an exception, raise exception, pragma exception_init, raise_application_error, exception scope, exception propagation, sqlcode, sqlerrm
- PL/SQL Oracle Packages (15:45)
package specification, package body, create or replace package, private and public objects, package initialization
- PL/SQL Oracle Triggers (24:05)
DDL triggers, DML triggers, compound triggers, instead-of triggers, event triggers, before, after, row-level trigger, statement-level trigger, for each row, create or replace trigger, inserting, deleting, updating, old, new, create sequence, view trigger
- Dynamic SQL, transactions (13:00)
execute immediate, using and into clauses, record type, commit, rollback, savepoint, rollback to savepoint
- Oracle Collections and Object Types (21:00)
varray, nested table, table of, associative array, extend, count, index by, cardinality, empty, member of, multiset intersect, multiset union, set, create or replace type, object specification, object body, member procedure, member function, object instance
- PL/SQL Oracle Bulk Collect (06:50)
bulk collect into, limit, performance improvement, bulk binding, loading data into collection, bulk fetching
- PL/SQL Oracle REF Cursors and SYS RefCursors (08:55)
ref cursor, sys_refcursor, cursor type as function/procedure result
- Materialized views refresh fast on commit (08:45)
fast-refreshable materialized views, materialized view log with rowid, refreshing view, refresh fast on commit
The PL/SQL Oracle training video explains basic and more advanced aspects of programming in Oracle 11g. It focuses on practical examples. Total length 3 h 2 min, video resolution 1280 x 720.
The Oracle Database is an object-relational database management system (relational database with added object-oriented features). Oracle responds with excellent performance in demanding environments. That makes it extremely popular in large companies. Oracle is one of the most powerful and complex software packages.
PL/SQL (Procedural Language extension of SQL) is a procedural language created by Oracle. It is a combination of SQL along with the procedural features of programming languages. PL/SQL allows to simplify application development and improve performance. The PL/SQL tutorial presents how to use PL/SQL to add business logic to a database application.