Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I really become confuse :( I want to export a data block data(a table of data included header and column data) into an excel form. I use Oracle 6,would you please help me to solve my problem?

in our office we have so many policy I can not create every thing that I want. :(

would you please provide a complete example for me?

my Os is :Win XP, Oracle form v 6

share|improve this question
add comment

1 Answer

I don't understand your issue totaly but if you have Oracle form v6 on your client then i guess that you are talking to a database RDBMS version x SID x therefore you can use sqlplus (you find that in your V6 installation) and spool your table query to a csv file which you can open with excel.

You can explicitly format the query to produce a delimited string with something along the lines of:

start sqlplus

connect user/password@some database SID


set echo off

set feedback off

set linesize 1000

set pagesize 0

set sqlprompt ''

set trimspool on

set headsep off

spool output.csv

select '"'||column1||'","'||column2||'"' from table_name;

results... results...

spool off


open the csv file in excel

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.