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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.