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 data control language? : Sql dba
What is the main difference between sql and pl/sql?
What is a pl/sql block?
Does a primary key have to be a number?
What is dbo in sql?
Which language is used in sql?
How we can update the view?
What has stored procedures in sql and how we can use it?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is sql catalog?
Why trigger is used in sql?
How is a process of pl/sql compiled?
Why coalesce is used in sql?
what is the difference between join and union? : Sql dba
How do you modify a column in sql?