AnsweredAssumed Answered

About column < data > in table < qti_asi_data > and table < qti_result_data >

Question asked by msmcchan on Dec 19, 2016

I have some questions that might need your help:

1.Could you help me to give more detailed information about column < data > in table < qti_asi_data > and table < qti_result_data > .

2.Is it possible retrieve full and readable data from these columns < data > in oracle SQL statement? If yes, could you send the oracle SQL statement to us? If no, could you suggest other methods to retrieve these data in full readable format?

 

I am currently using the following code to get the field, but some (long) records could not be retrieved completely.

utl_raw.cast_to_varchar2(dbms_lob.substr(qti_asi_data.data,2000,1))

 

 

 

Thanks

Outcomes