I have one Excel file with 1,50,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
I need PLSQL Procedure or used by SQL PLUS
Answers were Sorted based on User's Feedback
Answer / murthy
Please use the sql loader to upload the file into Oracle
database.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / madhu
I NEED PL/SQL PROCEDURE
we can't use sqlplus,why because we can't upload the data
in single statement,So we need pl/sql procedure
or else dump the data using with sql loader
by using command prompt in SQL LOADER
Is This Answer Correct ? | 9 Yes | 7 No |
Answer / aryasen
If you are using SQL Developer one option is there for
importing data from excel/csv or any other files.
first u need to create table which contains all columns in
excel. then right click on that table it will give option
for import excel data to the table.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / sajid siddiki
Please use sqlldr on UNIX or Ora Loader software to load any
kind of file(txt,xls) into system.
Is This Answer Correct ? | 1 Yes | 0 No |
yes, We can also import data in db by creating external table.So in this case, we can use sql plus too.
Is This Answer Correct ? | 0 Yes | 0 No |
What do you think about pl/sql?
What is the process of copying data from table a to table b?
What is an index and types of indexes. How many number of indexes can be used per table ?
12 Answers Accenture, BirlaSoft, Cognizant, CTS, Symphony,
Mention what are different methods to trace the pl/sql code?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is sql deadlock?
Explain the steps needed to create the scheduled job?
What is percent sign in sql?
What is sorting in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is t-sql? : Transact sql