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...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define overloaded procedure?

1077


What are literals in sql server?

1164


What does a pl/sql package consist of?

972


What is rowtype?

1015


what is the different between now() and current_date()? : Sql dba

1016


What does the file extension accdb stand for?

969


What is the mutating table and constraining table?

1024


Which operator is used in query for pattern matching?

1087


define join and explain different type of joins? : Sql dba

950


How do I count records in sql?

996


Can ddl statements be used in pl/sql?

1140


What is the difference between delete and truncate statement in sql?

1068


What is sql keyword?

997


Which table is left in join?

976


Explain the significance of the & and && operators in pl sql.

1007