raana jella
asked on
Substring from Clob or Blob column
I have a table with blob column which stores all comments entered by users for particular assest (asset01)
CommentHeaderuser1 CommentDate2014-08-15-14.4 8.14.00000 0
CommentDateStageNbr20Stage NbrComment HeaderComm entBodytes t 1 - first test CommentBody
CommentHeaderuser2 CommentDate2014-08-15-14.1 3.08.00000 0
CommentDateStageNbr20Stage NbrComment HeaderComm entBodyTes t 2 - Second TestCommentBody
User 1 entered comments test 1 - first test which is stored between commentbody and commentbody
User 2 eneterd Test 2 - Second Test which is stored between commentbody
How to query using sql to get these comments as seperate lines
Line 1 - Test 1 - FirstTest
Line 2 - Test 2 - Second Test
Table contains multiple assets and each asset will have comments stored in tags
CommentHeaderuser1 CommentDate2014-08-15-14.4
CommentDateStageNbr20Stage
CommentHeaderuser2 CommentDate2014-08-15-14.1
CommentDateStageNbr20Stage
User 1 entered comments test 1 - first test which is stored between commentbody and commentbody
User 2 eneterd Test 2 - Second Test which is stored between commentbody
How to query using sql to get these comments as seperate lines
Line 1 - Test 1 - FirstTest
Line 2 - Test 2 - Second Test
Table contains multiple assets and each asset will have comments stored in tags
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will try these solutions and will let you know