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 will you get by the cursor attribute sql%found?
What are the different types of a subquery?
What are sql objects?
What is lexical units in pl sql?
what is the difference between char_length and length? : Sql dba
What is cost in sql execution plan?
What do you mean by stored procedures? How do we use it?
What does seeding a database mean?
Is crud a cuss word?
What are sql ddl commands?
What are triggers and its uses?
Are subqueries better than joins?
Can we create clustered index without primary key?
What is rowtype?
What is difference between primary and secondary key?