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 are three advantages to using sql?

0 Answers  

---

How to prepare for oracle pl sql certification?

0 Answers  

---

What is denormalization in a database?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

what is meant by forward declaration in functions?

4 Answers   TCS,

---

What is the file extension for sql database?

0 Answers  

---

How can I see all tables in sql?

0 Answers  

---

how to present a past time in hours, minutes and seconds? : Sql dba

0 Answers  

---

What is record in pl sql?

0 Answers  

---

what command is used to create a table by copying the structure of another table including constraints ?

6 Answers   CMC, eicc,

---

What are reports usually used for?

0 Answers  

---

what is oracle database ? : Sql dba

0 Answers  

---