When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Oracle File Handling
Oracle File handing operation using UTL_FILE, SQL Loader and External Tables
This Course Includes
udemy
1 (25 reviews )
2h 31m 
english
Online - Self Paced
professional certificate
Udemy
About 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.
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..