Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 5903 Views
- I also Faced
- E-Mail Answers
Answer Posted / bibekananda pradhan
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 ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define join and enlist its types.
How to pump the data from one database to another?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
What are the objectives of rdbms?
What are the disadvantages of a query?
RDBMS file system can be defined as
Does netlib support windows 95?
What are the characteristics of data in the database?
What do you mean by aggregate and scalar functions in dbms?
What is rdbms data?
What are the four objectives of the selection of a data type?
What is data model in database?
What is called dbms?
What is 'cross join'? Or what is cartesian product?
In which format image is stored in database?
