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

Can we rollback truncate?

1083

---

define sql insert statement ? : Sql dba

1110

---

What is the current version of sql?

1106

---

what is sql server agent? : Sql dba

1188

---

what is dbms? : Sql dba

1070

---

how to escape special characters in sql statements? : Sql dba

1124

---

Is primary key clustered index?

1028

---

what are all the common sql function? : Sql dba

1141

---

Is inner join faster than left join?

1287

---

what is bcp? When does it used? : Sql dba

1065

---

Can delete statement be rollbacked?

1065

---

how to use regular expression in pattern match conditions? : Sql dba

1125

---

how many tables will create when we create table, what are they? : Sql dba

1155

---

Is primary key always clustered index?

1101

---

What is the best sql course?

1064

---