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 / cm

USE SQL LOADER

Is This Answer Correct ?    13 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rowid in sql?

502


What is a sql select statement?

562


What is sql constant?

500


What are the advantages of pl sql?

592


what are the different type of normalization? : Sql dba

548






What is self-join and what is the requirement of self-join?

626


how to include character strings in sql statements? : Sql dba

546


Which join is like an inner join?

519


Can we update views in sql?

527


What do you know by pl/sql cursors?

556


What is varchar used for?

527


Why we use cross join?

536


Difference between global and parameter variables?

1450


Are stored procedures faster than dynamic sql?

524


How do you optimize a stored procedure query?

561