Oracle File Handling

Oracle File Handling

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.

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

Url: View Details

What you will learn

• Learn the options available in Oracle to handle/manage "Operating system files".
• Use "UTL_FILE" package to read/write/copy/delete/rename files (in operating system).
• Gain understanding on using BLOB column to store & retrieve binary files.

Rating: 4.15

Level: Beginner Level

Duration: 2.5 hours

Instructor: Siva LK