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
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What has stored procedures in sql and how we can use it?
What do you think about pl/sql?
What is trigger in pl sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
Is sql easier than java?
Do stored procedures prevent sql injection?
What are tables and fields?
what is unique key constraint? : Sql dba
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Why do we need cursor in pl sql?
Is t sql a programming language?
How is data stored in sql?
What is sql lookup?
Write a query to display the current date in sql?