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 a data manipulation language?
What are all the different normalization?
what happens if null values are involved in expressions? : Sql dba
How global cursor can be declare with dynamic trigger ?
what is the stuff function and how does it differ from the replace function? : Sql dba
What is error ora-01000: maximum open cursors exceeded
How do you update a value in sql?
Explain the savepoint statement.
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is secondary key?
What is primary key and unique key?
What program will open a mdb file?
Define concurrency control. : Transact sql
What are the basic techniques of indexing?
Explain the types of joins in sql?