Recent content by eflavin

Hi there, my question is quite simple,is there another way of adding column headers to the spooled out data below in a way that each of the headers will go into an individual column in the excel file. The way of using the "From Dual" is a bit unsatisfactory in that all the headers are...

Hi there can anyone tell me how I would add column headers for each of the fields to the report file created from this statement. SET PAGESIZE 0 SET ECHO OFF SET FEEDBACK OFF SET LINESIZE 500 SEt TRIMSPOOL ON SPOOL C:\SPOOLED_OUT.csv SELECT...

Hi there I wonder could any give me a reason why running in the following SQL would give the error belowto a table would give this error. alter table SERV_INS add(ZSI_FREE_FIVE VARCHAR2(5)); update SERV_INS set ZSI_FREE_FIVE =' '; alter table SERV_INS...

Hello there I have a quick query. I am wondering how I would go about importing 2 tables from an oracle 8 database into an Access one. Looking the Oracle DB through Toad I tried exporting directly into my Access DB but was given an error, so I assume they are incompatable. Does anyone have any...