Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441

    Question Unanswered: Help....Long column problem

    Hi,
    I have a table which i wish to spool to a flat file. This however is causing problems as one of the columns is a LONG.

    I wish to do something like this;
    Code:
    select x||','||y||','||z from blahtable where blah<>blah
    I have tried the dump(columnName) thing to dump the raw data but it is incompatible. I cannot find any documentation on this subject

    I really need a suggestion, but it should be compatible with older versions of oracle if possible (specifically version 7.3 for Aplha).

    Many thanks

  2. #2
    Join Date
    Feb 2002
    Location
    San Francisco, CA
    Posts
    441
    Oh yeah, I am running oracle 9.0.1.1.1 if that makes any difference

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •