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 / madhu
I NEED PL/SQL PROCEDURE
we can't use sqlplus,why because we can't upload the data
in single statement,So we need pl/sql procedure
or else dump the data using with sql loader
by using command prompt in SQL LOADER
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
Define overloaded procedure?
What are literals in sql server?
What does a pl/sql package consist of?
What is rowtype?
what is the different between now() and current_date()? : Sql dba
What does the file extension accdb stand for?
What is the mutating table and constraining table?
Which operator is used in query for pattern matching?
define join and explain different type of joins? : Sql dba
How do I count records in sql?
Can ddl statements be used in pl/sql?
What is the difference between delete and truncate statement in sql?
What is sql keyword?
Which table is left in join?
Explain the significance of the & and && operators in pl sql.