الانتقال إلى المحتوى
View in the app

A better way to browse. Learn more.
مجموعة مستخدمي أوراكل العربية

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Sql-Loader With Example

  •
Black Angle
بواسطة Black Angle
في منتدى ادارة قواعد البيانات الــ DBA

Featured Replies

بتاريخ:

What is sql-loader

SQL LOADER is an Oracle utility used to load data into table given a datafile which has the records that need to be loaded. SQL*Loader takes data file, as well as a control file, to insert data into the table. When a Control file is executed, it can create Three (3) files called a

log file, bad file or reject file, discard file.

Log file tells you the state of the tables and indexes and the number of logical records already read from the input datafile. This information can be used to resume the load where it left off.

Bad file or reject file gives you the records that were rejected because of formatting errors or because they caused Oracle errors.

Discard filespecifies the records that do not meet any of the loading criteria like when any of the WHEN clauses specified in the control file. These records differ from rejected records

How Sql-Loader Works



sql-loader depend on two files first one is Control_file.ctl and the other one is Data_file.txt/.dat. the following figure show us the whole process:

ch03a2.gif

The way of writing and understanding the Sql-loader Script


Before starting there is something I want to mention it, the control_file.ctl and data_file.txt are depending on each others. Some time put them in command line and sometime data_file.dat include into the control_file.ctl by using infile = ‘datafile.dat’ the following script show this properties:

data_file.txt/.dat

1,Ibrahim,Jenin
2,Mohammad,Nablus
3,Ahmad,Ramallah

-Control_file.ctl

load data
infile ‘c:\data_file.txt/.dat’
truncate
into table table_name
fields terminated by “,” (id,name,city)

To use the sqlldr.exe utility. You can found it by run cmd.exe and then write the following statement:


c:\>sqlldr hr/hr@xe control = c:\control_file.ctl


For more information follow the following link:

http://psoug.org/ref.../sqlloader.html

  • اقتباس
    • أعجبني 1

    انضم إلى المناقشة

    يمكنك المشاركة الآن والتسجيل لاحقاً. إذا كان لديك حساب, سجل دخولك الآن لتقوم بالمشاركة من خلال حسابك.

    زائر
    أضف رد على هذا الموضوع...
    عودة لقائمة الموضوعات

    برجاء الإنتباه

    بإستخدامك للموقع فأنت تتعهد بالموافقة على هذه البنود: سياسة الخصوصية

    أوافق

    Account

    Navigation

    البحث

    إعداد إشعارات المتصفح الفورية
    Chrome (Android)
    1. Tap the lock icon next to the address bar.
    2. Tap Permissions → Notifications.
    3. Adjust your preference.
    Chrome (Desktop)
    1. Click the padlock icon in the address bar.
    2. Select Site settings.
    3. Find Notifications and adjust your preference.