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

why we use nocopy?

2 Answers   Polaris,

What is Highwatermark?

3 Answers   Thermotech,

How many types of triggers are there in pl sql?

0 Answers  

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,

Explain two easy sql optimizations.

0 Answers  

How do you update a table in sql?

0 Answers  

Why are indexes and views important to an organization?

0 Answers  

Explain the working of primary key?

0 Answers  

What is primary key sql?

0 Answers  

In a PL/SQL block,which loop type should be used in a performance point of view & Why (as both loops can do the same task) 1) open - Fetch loop 2) for loop

4 Answers   JDA,

Why cross join is used?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories