Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
How to get text from a field which datatype is BLOB
This is a discussion on How to get text from a field which datatype is BLOB within the Oracle forums, part of the Databases category; One of the fields is defined as clob data type. How can i get some text out of it. Example, in table "test" contains two fields "a", "b". "a" - ...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
08-29-2008
|
|||
|
|||
|
How to get text from a field which datatype is BLOB
One of the fields is defined as clob data type. How can i get some text out of it. Example, in table "test" contains two fields "a", "b". "a" - alphanumeric -> "this is a test" "b" - clob -> "this is a test for tough question" i have below sqls. When run get error. Select body from test or select substr(a, instr(a, 'this ')+9, instr(a, 'tough')) as id from test
|
| Sponsored Links |
|
08-29-2008
|
|||
|
|||
|
Re: How to get text from a field which datatype is BLOB
One of the fields is defined as clob data type. How can i get some text out of it. Example,
in table "test" contains two fields "a", "b". "a" - alphanumeric -> "this is a test" "b" - clob -> "this is a test for tough question" i have below sqls. When run get error. Select body from test or select substr(a, instr(a, 'this ')+9, instr(a, 'tough')) as id from test
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Exforsys.com Swing Extreme Testing - Getting the Text of a Text Field | admin | Web Design | 0 | 07-11-2008 12:40 AM |
| NCHAR datatype | krishnaindia2007 | Oracle | 2 | 11-30-2007 04:36 AM |
| Datatype for Updated_time | rameshpossible | Data Warehousing | 2 | 10-09-2007 02:57 AM |
| Create an index on table containg BLOB type | vidya_kr | Oracle | 0 | 04-24-2007 02:33 AM |
| Field, single field and multivalue field | JobHelper | Seibel | 1 | 01-10-2007 12:54 PM |
All times are GMT -4. The time now is 03:25 PM.
