Interested to Buy Any Domain ? << Click Here >> for more details...
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
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is trigger point?
Which language is used in sql?
What are pl sql data types?
What is a sql trace file?
List out the acid properties and explain?
how do you know if your mysql server is alive? : Sql dba
What are crud methods?
Explain ttitle and btitle.
How to move files from one directory to another in pl sql?
What is a string data type in sql?
What is the usage of when clause in trigger?
What is sql key?
How do you update f as m and m as f from the below table testtable?
What are actual parameters and formal parameters?
What is sqlservr exe?
