Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eflavin
  • Content: Threads
  • Order by date
  1. eflavin

    Column Headers

    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...
  2. eflavin

    Hi there can anyone tell me how I

    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...
  3. eflavin

    Oracle error?

    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...
  4. eflavin

    imports

    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...

Part and Inventory Search

Back
Top