Overview

This is a course on file handling operation in Oracle database using UTL_FILE package, SQL Loader Utility and External table. After completing this course, you will be able to 1. Understand file handling operation in oracle database using UTL_FILE package.2. Read content from text file using PLSQL code.3. Write into text file using PLSQL code.4. Copy file from source to destination folder.5. Remove a file from operating system.6. Generate HTML reports of data using PLSQL code.7. Store and retrieve binary data into/from oracle database.8. Read data from flat files using SQL loader utility.9. Read data from files using "External table" functionality.10. Export data using "External table" functionality.

Skills

Reviews