SET serveroutput ON
DECLARE
s_sql VARCHAR2(2000);
s_rez VARCHAR2(32767);
BEGIN
s_sql := ‘select LONG_COLUMN from SOME_TABLE where ID_COLUMN = 123′ ;
EXECUTE IMMEDIATE s_sql INTO s_rez;
– print it on the screen or convert/transform/search…
dbms_output.put_line ( s_rez [...]
Sometimes it’s necessary to convert Sybase timestamp to something more readable
Warning! Timestamp is not date type!
declare @p timestamp
declare @s varchar(16)
declare @t1, @t2 varbinary(4)
//— from char to timestamp
@t1 = hextoint(substring(lower(@s),1,8))
@t2 = hextoint(substring(lower(@s),9,8))
@p = @t1 + @t2
//— from timestamp to [...]
