ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
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 Submitted By :: Gurusuryas
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
# 1		 
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 ?    2 Yes 0 No
Madhu
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
How the execution will be done in exceptions?  2
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ? PreVator3
how to retrive only second row from table? IBM13
What is the difference between sql/pl-sql/embeded sql?  2
What is an index and types of indexes. How many number of indexes can be used per table ? BirlaSoft4
What are advantages of Stored Procedures? Satyam2
What is an Integrity Constraint?  3
how do u call in & out parameters for stored procedures? A1-Technology7
what is the command for user data type?  2
difference between oracle 8i and oracle 9i  5
What are the two parts of a procedure ? Hi-Caliber-IT4
what is the forward decleration in packages?  1
What is the usage of NVL? Infosys5
Store procedure will return a value? eMids2
What are user defined stored procedures ? BirlaSoft2
Differences between UNIQUE and DISTINCT in select statements Verinon-Technology-Solutions9
How packaged procedures and functions are called from the following?  1
If a View on a single base table is manipulated will the changes be reflected on the base table?  3
write a query to delete similar records in particular fields(columns) in different tables  2
What is an Exception ? What are types of Exception ?  2
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com