Answer Posted / 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

What is asqueryable?

951

---

Can we update views in sql?

925

---

What is the need of a partition key?

972

---

Can sql function call stored procedure?

993

---

Explain the select statement in sql?

1095

---

What is data profiling in sql?

1056

---

How many columns should be in an index?

951

---

How many types of sql are there?

979

---

What is the maximum number of columns in sql table?

1150

---

How do I find duplicates in sql?

916

---

What are pl/sql cursor exceptions?

1076

---

What is sql clause?

1035

---

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

991

---

What is a behavioral trigger?

961

---

what are the differences between require and include, include_once and require_once? : Sql dba

1008

---