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 are the different schemas objects that can be created using pl/sql?
Is progress software supports to ( pl/sql )?
How do you go back in sql?
How does an execution block start and end in pl sql?
Is keyword pl sql?
What do you mean by query optimization?
Define a temp table?
What is the use of <> sql?
Define select, insert, create, delete, update, drop keywords
How can we find duplicate records in a table?
What is a clob in sql?
Why do you partition data?
What is a table in a database?
Can we create foreign key without primary key?
What are data types in pl sql?
