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 data manipulation language? : Sql dba

0 Answers  

What is the difference between sql, mysql and sql server?

0 Answers  

How do I view tables in mysql?

0 Answers  

Can we rollback truncate?

0 Answers  

What is nvarchar in sql?

0 Answers  

What is right join sql?

0 Answers  

Explain autonomous transaction.

0 Answers  

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

Where the Pre_defined_exceptions are stored ?

2 Answers  

what is the order of pre-defined exceptions.

6 Answers   TCS,

explain primary keys and auto increment fields in mysql : sql dba

0 Answers  

what is a control file ? : Sql dba

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories