Home » Databases » Oracle – working with external files

 
 

Oracle – working with external files

 

This Oracle video tutorial explains basic and more advanced aspects of importing and exporting data in Oracle 11g. External tables and SQL*Loader are a very effective and useful mechanisms. The generation xml files, loading BLOB and CLOB into database are often found issue in various types of programs. Now, you can get this knowledge in 35 minutes. 7 lessons prepared by an expert will teach you all you need to know about importing and exporting files in Oracle.

  1. Importing a file into a BLOB datatype (05:48)
    Import BLOB Contents, Updating an existing BLOB
    buy single lesson
  2. Exporting the contents of a BLOB datatype to the filesystem (04:40)
    Using Java to export the BLOB
    buy single lesson
  3. Working with CLOB (06:05)
    Import CLOB Contents, Updating an existing CLOB, Export CLOB Contents
    buy single lesson
  4. Using external tables (06:01)
    Creating an External Table, External tables and XML files
    buy single lesson
  5. External tables containing CLOB and BLOB data (03:13)
    External tables and CLOB data, External tables and BLOB data
    buy single lesson
  6. XML generation in Oracle (05:12)
    Basic XML Generation, SYS_XMLGEN and SYS_XMLAGG
    buy single lesson
  7. Using SQL*LOADER to load data (04:15)
    Using SQL*Loader to Load File
    buy single lesson

Price 19.00 USD


Frequently Asked Questions

Watch sample lesson and see how fast and easy discovering new knowledge can be:

Tags: , ,