CLOBs and MS Query - How to get info out
In the Open Standard
Thomas LeahyMember for 22 years 4 months
- Created
- 0
- 3
0
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.
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.
Replies
Oldest firstNo replies yet. Be the first to answer.
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?