Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17553 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what is a composite key ? : Sql dba
What is an inconsistent dependency?
Write the command to remove all players named sachin from the players table.
Can we use loop in sql?
What are the two parts of design view?
How exception is different from error?
How do I remove duplicates in two columns?
Define select, insert, create, delete, update, drop keywords
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
is mysql query is case sensitive? : Sql dba
How much does sqlite cost?
Does truncate remove indexes?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What does trigger mean in slang?
how can we know the count/number of elements of an array? : Sql dba
