Answer / arup ratan banerjee

By means of Sqlloader

steps
------
1) Save the excel file as .csv
2) Give proper column headings
3) create a file named sqlload.ctl where u will write

load data
infile 'C:\HR_EMP_LWP_TMP.csv'
REPLACE
into table HR_EMP_LWP_TMP
fields terminated by ','
(emp_NO,yr_mon,lwp)

4) Load Oracle Client 9i

From command prompt run

c:\oracle_client9i\bin\sqlldr <user/password@tnsname>
sqlload1.ctl

5) The excel file gets converted to Table in Oracle

Answer / ts mishra dba

load data
infile 'c:\head.csv'
replace
into table allotment
field terminated by ',' optianally enclosed by '"'
trailing nullcols
(ALLOTMENT_ID,ALLOTMENT_DATE,DEMAND,MAGOR,SUB,MINOR,SCHEEM,S
EGMENT,OBJECT,DETAIL,AMOUNT,DDO_CODE)


run at run command this
sqlldr scott/tiger@ntts control=c:\head.ctl

What is a bitmap index?

4 Answers   Choice Solutions, Infosys,

---

What is mutating error?

0 Answers  

---

I have a Employee table with columns ename,eid,salary,deptno. How to retrieve sum of salary for each deptno?

8 Answers   L&T,

---

What is plpgsql language?

0 Answers  

---

Is left join same as inner join?

0 Answers  

---

---

which types of join is used in sql widely? : Sql dba

0 Answers  

---

i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.

3 Answers  

---

what are the types of subquery? : Sql dba

0 Answers  

---

What is sql dialect?

0 Answers  

---

What is dialect in sql?

0 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

What schema means?

0 Answers  

---