Oracle File Handling

Oracle File Handling udemy course free download

Oracle File handing operation using UTL_FILE, SQL Loader and External Tables

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.