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

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

how to debugg a procedure or package using dbms_output.put_line in plsql

1 Answers   Polaris,

---

differentiate between float and double. : Sql dba

0 Answers  

---

What is a full join?

0 Answers  

---

What is Materialized View? In What Scenario we Use Materialized View?

2 Answers   Dinesh, Marlabs,

---

how to create object in plsql

3 Answers   Microsoft,

---

What is microsoft t sql?

0 Answers  

---

How is a PL/SQL code compiled?

0 Answers  

---

How do I start pl sql?

0 Answers  

---

What do you understand by pl/sql packages?

0 Answers  

---

what is index? : Sql dba

0 Answers  

---

Regarding joins what are the differences you observed in oracle 9i and sql server?

3 Answers   Choice Solutions,

---