Answer / Shiv Prakash

To load Microsoft Excel data into Oracle using SQL*Loader, follow these steps:

1. Save the Excel data as a delimited text file (CSV format).
2. Create an external table in Oracle that corresponds to your CSV file.
3. Use SQL*Loader to load the data from the CSV file into the external table.

What is clustered and nonclustered index in sql?

1 Answers  

---

How do you update a value in sql?

1 Answers  

---

Write a sql to print only character form the below string. @So&*CIE%$TE@GEN!@RAL

1 Answers   Societe Generale,

---

Compare sql & pl/sql

1 Answers  

---

Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

What is the main reason behind using an index?

1 Answers  

---

How many sql core licenses do I need?

1 Answers  

---

What are the different ways to optimize a sql query?

1 Answers  

---

how to convert character strings to numeric values? : Sql dba

1 Answers  

---

What is the difference between a primary key and a unique key?

1 Answers  

---

Can you have more than one key in a database?

1 Answers  

---

how many sql dml commands are supported by 'mysql'? : Sql dba

1 Answers  

---