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.

How to add a new column to an existing table in oracle?

0 Answers  

---

Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers  

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---

What is a Database instance ? Explain?

3 Answers  

---

What are the values that can be specified for OPTIMIZER MODE Parameter ?

1 Answers  

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---

What happens to the indexes if a table is recovered?

0 Answers  

---

In Oracle 10g, "g" Stands for what?

5 Answers   Mphasis,

---

Does oracle charge for java?

0 Answers  

---

which statement is running fastly ie insert or delete?

13 Answers   Oracle,

---

What is a partition in oracle?

0 Answers  

---

How to display row numbers with the records?

0 Answers  

---