Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Extract Data using clob fields

Status
Not open for further replies.
kizziebutler

kizziebutler

Programmer
Apr 28, 2005
81
GB
I am trying to extract a field that contains XML coding, includes spaces etc and this is defined as a clob field. Is there any way I can extract this field so that all the formatting is retained when viewed in a csv. This is going to be imported into an other database so I need to retain all the formatting of this field.
 
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question
Data encryption in Oracle 19c
Replies
0
Views
279
rk68
rk68
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
1K
carp
carp
mibeach7
  • Locked
  • Question
OEM extract ORA- from string text 1
Replies
2
Views
389
mibeach7
mibeach7
TheLazyPig
  • Locked
  • Question
Oracle Data Validation 1
Replies
4
Views
444
TheLazyPig
TheLazyPig
kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
457
carp
carp

Part and Inventory Search

Sponsor

Back
Top