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
How to sort the rows in sql.
What is a sql instance vs database?
How do I copy a table in sql?
How subquery works in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
Do stored procedures prevent sql injection?
What is difference between ms sql and mysql?
How to download oracle sql developer?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is difference between nchar and nvarchar?
What is varray in pl sql?
What is rtm in testing?
Can ddl statements be used in pl/sql?
Why cross join is used?
