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 sql profiling in oracle?

1064

---

What are few of the schema objects that are created using PL/SQL?

1039

---

What are the types of records?

988

---

What is difference between rank () row_number () and dense_rank () in sql?

1101

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3050

---

Can we enter data in a table in design view?

969

---

When is the update_statistics command used?

1120

---

Does sql support programming?

1073

---

what is blob? : Sql dba

1149

---

Which command is used to delete a trigger?

1333

---

Is sql a case sensitive language?

947

---

what are sequences

1748

---

What is pl sql collection?

970

---

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1209

---

Which is better join or inner query?

1048

---