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
Answer Posted / abhishekjaiswal
yes, We can also import data in db by creating external table.So in this case, we can use sql plus too.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the difference between having and a where in sql?
What is schema in sql example?
What is the primary use of normalization?
What is query optimization in sql?
What is the difference between explicit and implicit cursors in oracle?
what is the difference between primary key and unique key? : Sql dba
What is implicit cursor in pl sql?
Explain character-manipulation functions?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
How do I start sql from command line?
What is schema in sql?
What is a system versioned table?
What is Collation Sensitivity ? What are the various type ?
Why do we use partitions in sql?
How can check sql version from command line?