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
- 17810 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 advantage of nosql?
Can you have more than one trigger on a table?
What is composite primary key in sql?
What is column?
How do I view an execution plan in sql?
how many values can the set function of mysql take? : Sql dba
What is the primary key?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
What is a common use of group by in sql?
Can we debug stored procedure?
Is coalesce faster than isnull?
What is composite data type in pl sql?
Which constraints we can use while creating database in sql?
What is constant in pl sql?
What is the difference between rollback and rollback to statements?
