Oracle File Handling

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

Ratings 4.09 / 5.00

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.
Use "SQL loader" utility to load data from text files into oracle database table.
Understand "External Tables" to import data from text files to database.
Understand "External Tables" to export data from database to text file.

Description

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.

Who Should Attend!

This course is for oracle PLSQL developers who want to do file handling operations from database.
To know the different options available in oracle database with respect to file handling.
Anyone interested in learning file handling operations in operating system from oracle database.
For any enthusiastic oracle learner.

TAKE THIS COURSE