Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
- 3 Answers
- 10569 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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
| Is This Answer Correct ? | 2 Yes | 2 No |
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.
| Is This Answer Correct ? | 0 Yes | 2 No |
What is a system tablespace?
What is Row Chaining ?
What is a schema in oracle?
How to loop through a cursor variable?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What are the parameters that we can pass through a stored procedure?
What is a tns service name?
can you write commit in triggers?
What is a relational database management system?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is literal?
what are the different types of cursors? explain?
Oracle General 
