Published on Planning Planet (http://www.planningplanet.com)

Home > Discussion Forum > CLOBs and MS Query - How to get info out

CLOBs and MS Query - How to get info out

By Thomas Leahy
Created 15 Jun 2004 - 05:42
Submitted by Thomas Leahy on Tue, 2004-06-15 05:42
Just a note:
I was having trouble getting CLOBS out of an Oracle based P3ec installation. I have found that the following works

(obs_descr is a CLOB)

SELECT substr(to_char(obs_descr),1,200)
FROM ADMUSER.obs obs

Output:
9696776

The entry was 9696776

As you can see it came out in HTML format.

By logging in, inputting data or deciding to view any further of our pages you agree to be bound by our Forum Rules, our T&C's and also our Privacy Policy
© Planning Planet 2000-2024. Run by Project Controllers for Project Controllers.
Source URL: http://www.planningplanet.com/forums/primavera-version-pm5-pm6/412018/clobs-and-ms-query-how-get-info-out

Links:
[1] http://www.planningplanet.com/forums/oracle-primavera-pm6