Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What is difference between Oracle API and Oracle SQL Loader?

user-image
Question added by khaled Elrawy , صاحب الشركة , مكتب خالد الراوي للمحاسبة والمراجعة وأنظمة الكمبيوتر
Date Posted: 2015/02/21
Mohamed Mahmoud Samy EL Haddad
by Mohamed Mahmoud Samy EL Haddad , Senior Oracle Applications , Egyptian for Projects Operation and Maintenance (EPROM)

"Oracle SQL Loader" is a direct upload utility available in Oracle DB , using it you can get data from a text file directly into a database table in oracle.

"Oracle API" is a set of packages prepared by Applications teams to give the programmers a facility to design and create their own upload process.

Usually we use the SQL Loader to get the data to a temp table in the DB then we use the APIs to apply the rules we need and to upload the data into Oracle eBusiness Suite.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.