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 are the advantages of pl sql over sql?
How do you write an index?
What is the life of an sql statement?
What is cursor and why it is required?
What is the usage of sql functions?
Why we use sql profiler?
How global cursor can be declare with dynamic trigger ?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What is a recursive join sql?
what are the 'mysql' command line arguments? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
What are all ddl commands?
Why do we create stored procedures & functions in pl/sql and how are they different?
How do I view an execution plan in sql?
What is memory optimized table?