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
- 17261 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / yankee
Probably, u have to save the file in ur hard disk(namely in
ur D drive) first eg. sourav.txt
Then open pl/sql developer and open a command window. And
then type in: @ D:\sourav.txt
All the rows will be updated.. finally "commit" it.
| Is This Answer Correct ? | 2 Yes | 14 No |
Post New Answer View All Answers
What is the difference between an inner and outer join?
What is a pragma statement?
What are all the ddl commands?
What is a pl/sql block?
What are the different types of dbmss?
Which is faster union or join?
What is trigger point?
What is a heap in sql?
What is the difference between microsoft access and sql?
how does a local variable is defined using t-sql? : Transact sql
What is the difference between having and a where in sql?
What is difference between inner join and self join?
What are different types of keys?
what happens if null values are involved in expressions? : Sql dba
How many sql commands are there?
