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 data integrity? : Sql dba

679


what is the difference between sql and t-sql? : Transact sql

701


What are character functions?

710


What happens when a trigger is associated to a view?

593


Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

765






What is clause?

692


What is substitution variable?

674


What are the methods of filing?

596


what does the t-sql command ident_incr does? : Transact sql

700


what is not null constraint? : Sql dba

633


What is left join example?

592


Explain what is a view?

705


What do you mean by stored procedures?

644


How long does it take to learn pl sql?

696


Is foreign key mandatory?

642