Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Oracle File Handling

Oracle File handing operation using UTL_FILE, SQL Loader and External Tables
4.0
4.0/5
(19 reviews)
135 students
Created by

7.4

CourseMarks Score®

5.0

Freshness

7.8

Feedback

8.8

Content

Platform: Udemy
Video: 2h 31m
Language: English
Next start: On Demand

Table of contents

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.

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.

Requirements

• Students should be familiar with basic Oracle SQL & PLSQL programming.
• Students should be comfortable is using any one tool like SQL developer, TOAD etc.
• Students should be familiar with basic SQLPlus commands

This course is for

• 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.
CODER # TRAINER # LEARNER
Browse all courses by on Coursemarks.
Platform: Udemy
Video: 2h 31m
Language: English
Next start: On Demand

Students are also interested in