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

How do you select unique values in sql?

994

---

Can you join views in sql?

948

---

How do I save a sql query?

1002

---

What is normalization in a database?

1150

---

What types of commands can be executed in sql*plus?

1101

---

What schema means?

882

---

What are reports usually used for?

1017

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1085

---

What is trigger explain with example?

1024

---

What is the use of sqldataadapter?

964

---

Is sql the best database?

964

---

Does mysql_real_escape_string prevent sql injection?

942

---

What is the main reason behind using an index?

1010

---

explain what is mysql? : Sql dba

1074

---

Can we insert data in view?

953

---