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.

what is difference between where clause and having clause?

13 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

0 Answers   Wipro,

---

Is primary key indexed by default in oracle?

0 Answers  

---

How to export several tables together?

0 Answers  

---

Who developed oracle & when?

0 Answers  

---

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers   Zensar,

---

what is IDE,DMV in sql server?

0 Answers  

---

How can we find out the current date and time in oracle?

0 Answers  

---

what is cartesian product?

2 Answers  

---

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,

---

How many memory layers are in the shared pool?

1 Answers  

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---