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
- 17535 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
How do I save the results of sql query in a file?
Why do we use cursors?
Which is the correct statement about truncate and delete?
What is sql partition function?
If a cursor is open, how can we find in a pl/sql block?
What are different types of functions in sql?
What is procedure in pl sql?
Can we edit a view in sql?
What do you mean by dbms? What are its different types?
How do I write a cron which will run a sql query and mail the results to agroup?
how to convert character strings to numeric values? : Sql dba
What is secondary key?
What is difference between table and view?
Advantages and disadvantages of stored procedure?
When to use inner join and left join?
