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   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Database Management
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
I have one Excel file with 80,000 Records. Now I need to
load that whole file into Oracle Database with same columns
in Excel sheet .
How can i do that?
 Question Submitted By :: Gurusuryas
I also faced this Question!!     Rank Answer Posted By  
 
  Re: I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?
Answer
# 1
An excel file cannot store more than 64K records. 

To load an excel file, we will have to convert it to a
delimited format. the load it using sqlldr
 
Is This Answer Correct ?    3 Yes 1 No
Shamimul
 
  Re: I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?
Answer
# 2
Sqlldr is kinda oldschool these days, external tables is 
the way to do it with the delimited file.
 
Is This Answer Correct ?    1 Yes 1 No
Ur_momma
 
 
 

 
 
 
Other Database Management Interview Questions
 
  Question Asked @ Answers
 
How can you CALL Reports from Forms4.0 ?  1
Are Constraints exported through Export command?  1
What is a logical backup ?  2
What is the use of FULL option in EXP command ?  1
What are the steps involved in Database Shutdown ?  1
Where the Databases overall structure is maintained ?  1
Name the two files that are created when you generate a form ?  1
What is the use of SHOW option in IMP command ?  1
What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?  1
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance? eBay1
Is it possible to modify a Datatype of a column when column contains values?  1
What is the use of FILE option in IMP command ?  1
Can MULTIPLE DOCUMENT INTERFACE (MDI) be used in Forms 4.5 ?  1
Can the User set Archive file name formats ?  1
What is the use of IGNORE option in IMP command ?  1
What does DLL stands for ?  2
Where does the LGWR process writes information?  1
What is Archived Redo Log ?  1
what is the use of SYSTEM.EFFECTIVE.DATE varaible ?  1
What are the factors causing the reparsing of SQL statements in SGA?  1
 
For more Database Management 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