Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between the SQL*Loader and IMPORT
utilities?
- 1 Answers
- 5326 Views
- I also Faced
- E-Mail Answers
Answer / swetha
1) sql*loader is used only to load data into database
tables from external files.
It's all about data loading.
2) Import is used to read and write the operating system
files in and out of database.
it's completely a different aspect.
We can deal with structures as well as data here.
We can import entire database or a particular user/schema
or required table spaces with structures or even with data
according to the requirement.
| Is This Answer Correct ? | 3 Yes | 0 No |
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What is auto invoicing? Explain : oracle accounts receivable
what is sql*loader parameters and where we will use it.
What background process refreshes materialized views?
write a query to find the third maximum salary of a employee.(table:employ col name:salary)
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
When creating a user, what permissions must you grant to allow them to connect to the database?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
wht r the base tables & primary key for BOM& WIP modules
how to display last 5 letters from a name (take emp table ename )
What command would you use to encrypt a PL/SQL application?
how to get the values if source table & target table having duplicate values that matches the lookup condition ?(i want all duplicate match)
Oracle General 
