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 does the argument [or replace] do?

0 Answers  

---

Explain the the update statement in sql?

0 Answers  

---

What is varchar sql?

0 Answers  

---

Explain what is a subquery ?

0 Answers  

---

How many joins in sql?

0 Answers  

---

What are expressions?

0 Answers  

---

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---

Difference between a query and strored procedure?

4 Answers   Microsoft,

---

What is primary and foreign key?

0 Answers  

---

How can get second highest salary in sql?

0 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---