Answer / mats önnerby

Set up an ODBC connection with the database.
Then from Excel menu, select Data => Import external data
=> New database query. From there it is intuitive.

Answer / karthik

In SQL Prompt:
-------------
set lines 100 pages 100;
set colsep"|"
spool c:\Datas.xls;
select * from emp
/
spool off;

In Excel Sheet, use Text to Column->Delimeter to replace
the "|" pipe symbol

Answer / ron

don't have a simple answer, you'll need to use oracle utils,
util_file and packages:
read about it in detail to download and running package at
website below:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:728625409049

hope this helps.

can we insert any row to dual table if i got the permission from DBA

5 Answers   HCL, Tesco,

---

What are a cluster and non-cluster index?

0 Answers  

---

what is index?

4 Answers  

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

How will you identify oracle database software release?

0 Answers  

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

0 Answers   Wipro,

---

What are the extensions used by oracle reports?

0 Answers  

---

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---

when do u go for hash partitioning?

1 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

What are the factors causing the reparsing of SQL statements in SGA?

1 Answers  

---

which language is used to develop the oracle........?

4 Answers   Infosys,

---