Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

Your Answer


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.