Long2Number

Hi,

I need to convert a Long-Datatype to a Number-Datatype.
Is that possible?

best regards Jolli

Bad news - you can't use data conversion functions on the long datatype with the exception of TO_LOB() which won't help you very much.

AFAIK....

Assuming the LONG is already in a table, you could try creating your own function such as

create or replace function x return number is
v_big_char varchar2(32000);
begin
select TRIGGER_BODY
into v_big_char
from user_triggers
where rownum = 1;
return to_number(v_big_char);
end;

Obviously you'd have to pass the key(s) into the function so it could select the right value.