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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is table? : Sql dba

1062


Name some usages of database trigger?

1019


What is procedure and function in sql?

998


What are triggers and its uses?

1046


Why is sharding used?

995


what is sql server agent? : Sql dba

1103


What port does sql server use?

1061


What is a native sql query?

1069


What are the benefits of triggers?

1172


What's the difference between inner join and left join?

999


Write a unique difference between a function and a stored procedure.

996


What is the difference between mdf and ndf files?

1119


How to read xml file in oracle pl sql?

913


Which tcp/ip port does sql server run?

1007


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2023