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 pivot in sql?
What is procedure and function in sql?
Can you call pl/sql package functions from within a fast formula?
What are the possible values for the boolean data field?
What is synchronized subquery?
Is drop table faster than truncate?
What is the main difference between sql and pl/sql?
What is left join in sql?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What is record type in pl sql?
What is the limitation on the block size of pl/sql?
Why cross join is used?
What are the various levels of constraints?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
What are the benefits of stored procedures?