-
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 ??
Thanks.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|