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

Please use the sql loader to upload the file into Oracle
database.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference in execution of triggers and stored procedures?

561


What does desc stand for?

584


How many parts of a pl sql block are optional?

513


What is the difference between delete and truncate statement in sql?

484


What is the difference between a query and a report?

508






Is a view faster than a stored procedure?

540


Explain the difference between 'between' & 'and' operators in sql

524


What is the difference between syntax error and runtime error?

609


How do you create an update query?

515


what is top in tsql? : Transact sql

533


What is the starting oracle error number? What is meant by forward declaration in functions?

536


How many sql statements are used? Define them.

571


Is sql workbench free?

523


how to include numeric values in sql statements? : Sql dba

555


Can you sum a count in sql?

549