Query a LONG column ?? possible ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Query a LONG column ?? possible ??

  1. #1
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Lightbulb

    A table has a column of datatype LONG. We are unable to query the table with this column in the WHERE clause.

    Any way to do this ? Is this possible.

    Thanks & Regards.


  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    If it is not possible to query a table based on a LONG (datatype) column, can we change it to VARCHAR and load it with data from this LONG column ??

    Thanks.


  3. #3
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865

    Thumbs up

    Found the solution !!

    It is not possible to change a long to a varchar using the ALTER TABLE command. Instead add a new column as varchar, and select the long into a PL/SQL variable, then insert into the varchar column.

    create or replace procedure covet is
    cursor c1 is
    select rowid,
    from ;
    begin
    for c2 in c1 loop
    update
    set =
    where rowid = c1.rowid;
    end loop;
    end;

    Cheers.


Posting Permissions

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


Click Here to Expand Forum to Full Width