Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / guest
Sql * loader is a bulk loader utility used for moving data
from external files into the oracle database.
Sql * loader supports various load formats, selective
loading, and multi-tables loads.
1) conventional
--The conventional path loader essentially loads the
data by using standard ?insert? statement.
2) direct
-- the direct path loader (direct = true)
by possess of logic involved with that, and loads directly
in to the oracle data files.
EX:-
My data.csv file
1001, ?scott tiger?,1000,40
1002,?gvreddy?,2345,50
Load data
Infile ?c:\data\mydata.csv?
Into table emp
Fields terminated by ?,? optionally enclosed by ???
(empno, empname,sal,deptno)
>sqlldr scott/tiger@vis
control=loader.ctl log= gvlog.log bad=gvbad.bad
discard=gvdis.dsc .
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How is choreography different from orchestration?
please send me forms, xml pulisher questions,answers
What is the concept of soa governance?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Tell me how to find the custom directory in front end?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
tell my any difficult situtation you solved in your experience in your company?
Tell me how to debug the report?
please any one provide the oracle erp technical interview questions on modules(PO,AP,AR,INV,GL,OM)wise to my mail id..narendra_609@yahoo.co.in
What are the different components of soa suite?
Do you know where we can check the status of po?
Can we create tables in apps schema?
What do you understand by soa and what are the benefits of using this architecture?
how do you describe O2C along with tables
How many schemas we have? how many you have used?
