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.
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 ??
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
for c2 in c1 loop
where rowid = c1.rowid;
Click Here to Expand Forum to Full Width