Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 implicit cursor in pl sql?

0 Answers  

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

How does cross join work?

0 Answers  

Store procedure will return a value?

4 Answers   eMids,

What is oracle pl sql developer?

0 Answers  

What is the difference between sql and isql*plus?

0 Answers  

Why do you partition data?

0 Answers  

what are the different type of normalization? : Sql dba

0 Answers  

What does count (*) mean?

0 Answers  

What does select count (*) mean in sql?

0 Answers  

Is mariadb a nosql database?

0 Answers  

what is a sub query?how will you calculate working days in a month using sub query?

4 Answers   InteQ,

For more SQL PLSQL Interview Questions Click Here
Categories