Hi API stands for application program interface
oracle has it,s own api facility to transfer data from a 
external source to oracle base table
so api is an standard oracle tool to trnsfer data to oracle 
database.it is a very simple method and a person with no 
technical background also can use api
example-uploading jounal and budget data through api


srinibas
oracle_sri08@rediffmail.com