Setup Menus in Admin Panel

Oracle SQL*Loader

130 STUDENTS ENROLLED
  • Profile photo of Monika
  • Profile photo of Niloj
  • Profile photo of Saloni Singh
  • Profile photo of Sanmukh
  • Profile photo of Kashif Iqbal

SQL*Loader loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. You can use SQL*Loader to do the following:

  • Load data across a network. This means that you can run the SQL*Loader client on a different system from the one that is running the SQL*Loader server.
  • Load data from multiple datafiles during the same load session.
  • Load data into multiple tables during the same load session.
  • Specify the character set of the data.
  • Selectively load data (you can load records based on the records’ values).
  • Manipulate the data before loading it, using SQL functions.
  • Generate unique sequential key values in specified columns.
  • Use the operating system’s file system to access the datafiles.
  • Load data from disk, tape, or named pipe.
  • Generate sophisticated error reports, which greatly aid troubleshooting.
  • Load arbitrarily complex object-relational data.
  • Use secondary datafiles for loading LOBs and collections.
  • Use either conventional or direct path loading. While conventional path loading is very flexible, direct path loading provides superior loading performance.

Course Reviews

N.A

ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

TAKE THIS COURSE
  • FREE
  • UNLIMITED ACCESS

Advanced Course Search Widget

Recent Posts

  • Starting a Startup

    Lorem ipsum dolor sit amet, consectetur adipiscing elit. Duis vestibulum turpis...

X