Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .