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
- 7 Answers
- 15232 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / cm
USE SQL LOADER
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
What is an escape character in sql?
Can we use ddl statements in stored procedure sql server?
What is rank function in sql?
what is table? : Sql dba
Why we use triggers in mysql?
What is scalar function?
Explain the working of foreign key?
what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba
Can we use rowid as primary key?
what is a constraint? Tell me about its various levels. : Sql dba
How do you declare a constant?
Why are aggregate functions called so?
How can you know that statistics should be updated?
what are the differences between char and nchar? : Sql dba
How can you fetch first 5 characters of the string?
