Answer Posted / 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 |
Post New Answer View All Answers
How to put more than 1000 values into an oracle in clause?
How to use values from other tables in update statements using oracle?
What is oracle latest version?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
How to start an oracle instance?
