1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / gurusuryas

Answers were Sorted based on User's Feedback



I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

Answer / cm

USE SQL LOADER

Is This Answer Correct ?    13 Yes 0 No

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

Answer / murthy

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

Is This Answer Correct ?    3 Yes 0 No

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

Answer / madhu

I NEED PL/SQL PROCEDURE

we can't use sqlplus,why because we can't upload the data
in single statement,So we need pl/sql procedure
or else dump the data using with sql loader

by using command prompt in SQL LOADER

Is This Answer Correct ?    9 Yes 7 No

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

Answer / aryasen

If you are using SQL Developer one option is there for
importing data from excel/csv or any other files.
first u need to create table which contains all columns in
excel. then right click on that table it will give option
for import excel data to the table.

Is This Answer Correct ?    4 Yes 2 No

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

Answer / sajid siddiki

Please use sqlldr on UNIX or Ora Loader software to load any
kind of file(txt,xls) into system.

Is This Answer Correct ?    1 Yes 0 No

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

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

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Databas..

Answer / yankee

Probably, u have to save the file in ur hard disk(namely in
ur D drive) first eg. sourav.txt
Then open pl/sql developer and open a command window. And
then type in: @ D:\sourav.txt
All the rows will be updated.. finally "commit" it.

Is This Answer Correct ?    2 Yes 14 No

Post New Answer

More SQL PLSQL Interview Questions

what is the difference between granting and creating a view?

2 Answers  

How do you write an index?

0 Answers  

Is id a reserved word in sql?

0 Answers  

What is native sql query?

0 Answers  

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  




When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

Can procedure in package be overloaded?

0 Answers   EXL,

Can we alter stored procedure?

0 Answers  

What are reports usually used for?

0 Answers  

How do I edit a stored procedure?

0 Answers  

Does oracle roll back the transaction on an error?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories