How to load excel data sheet to oracle database
- 1 Answers
- 1105 Views
- I also Faced
- E-Mail Answers
Answer / Dhirendra Shukla
There are several ways to load an Excel data sheet into an Oracle database. One common method is using SQL*Loader, a tool for bulk loading data from various data sources into Oracle tables.nn```sqln-- Prepare the control filenLOAD DATAnINFILE 'path/to/your_excel_file.xls'nREPLACEnINTO TABLE table_namenFIELDS TERMINATED BY 't' (FORMAT EXCEL HEADER=1)n-- Run the SQL*Loader commandnsqlldr username/password@db_connection control=path/to/your_control_file.ctl;n``
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I escape a reserved word in oracle?
When do you get a .pll extension in oracle?
What is a nvl function? How can it be used?
Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou
what are the diffeenes between oracle 9i,oracle 10g
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is the difference between postgresql and oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
What is sharded cluster?
What happens if you set the sga too low in oracle?
How to find out what privileges a user currently has in oracle?
What are the sql clauses supported in the link property sheet ?
Oracle General 
