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

what is the correct way of selection statement a. select/from/table_name/orderby/groupby/having b. select/from/table_name/groupby/having/orderby

5 Answers   HCL, JPMorgan Chase,

---

how to extract a unit value from a date and time? : Sql dba

0 Answers  

---

Is record in oracle pl sql?

0 Answers  

---

What are local and global variables and their differences?

0 Answers  

---

How many LONG columns are allowed in a table?

6 Answers   CTS,

---

What is normalisation and its types?

0 Answers  

---

What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,

---

How do I audit the sql sent to the server?

0 Answers  

---

what is user defined functions? : Sql dba

0 Answers  

---

How does an execution block start and end in pl sql?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

Why function is used in sql?

0 Answers  

---