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

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

how can i create a user defined datatype

3 Answers  

How much does sql cost?

0 Answers  

What is integrity in sql?

0 Answers  

What is the command used to fetch the first 5 characters of a string?

0 Answers  

What is difference between ms sql and mysql?

0 Answers  

how to create object in plsql

2 Answers   TCS,

How do you create a unique index?

0 Answers  

how to get second highest salary in SQL(as/4000

29 Answers   iGate,

Why self join is used in sql?

0 Answers  

What are the two types of exceptions.

0 Answers  

difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,

For more SQL PLSQL Interview Questions Click Here
Categories