Answer Posted / arijitnit

sql*loader is a bulk importing tool to import data tables
present in various formats like CSV.
We have to define a control file and in it we have to give
some commands.
LOAD DATA
INFILE *(this assumes data is in the same ctl file)
INTO TABLE TABLE_NAME(COLUMNS)
FIELDS TERMINATED BY ;
BEGIN DATA

...DATA IN CSV FORMAT
now in command prompt type sqlldr USERID=scott/tiger
CONTROL=test.ctl

What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?

2099

---

Could you please let me know the interfaces in OM / FA??

2186

---

PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

2161

---

What is the use of lockboxes? : oracle accounts receivable

1156

---

How many segment are present in Oracle Manufacturing

2259

---

how to write customizations in po

1559

---

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2471

---

What view would you use to determine free space in a tablespace?

2167

---

types of receipts and detail desription about recipts and tables effected by receipts?

2014

---

Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?

7910

---

default triggers available for reports

2157

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

2464

---

what is semphore explian it?

2739

---

what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?

2166

---

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1956

---