Home > Default > How to convert CLOB data (now it is in html format) to Normal text format

How to convert CLOB data (now it is in html format) to Normal text format

November 30Hits:0
Advertisement
Hi,
Can anybody let me know the solution for how to convert CLOB data into normal Text.In my case the table column having CLOB datatype and the data is in html format.when i run the report the column is displaying html tags .Now i need to convert that html tags into normal text.
Pl. let me know if any one know the solution.
Regards,
Thulasi.K

Answers

LONG has been depricated since 8i so I don't believe there is a general solution to go backwards short of reloading the data.
Justin

Read other 2 answers

Tags:

Related Articles

  • How to convert CLOB data (now it is in html format) to Normal text formatNovember 30

    Hi, Can anybody let me know the solution for how to convert CLOB data into normal Text.In my case the table column having CLOB datatype and the data is in html format.when i run the report the column is displaying html tags .Now i need to convert tha

  • Problems converting FILETIME date/time into MM/DD/YYYY format...November 30

    Has anyone successfully converted a FILETIME date/time value into a MM/DD/YYYY format using ColdFusion? I am failing drastically, and it seems like an easy conversion. FILETIME format (details: http://msdn.microsoft.com/en-us/library/windows/desktop/

  • Convert clob to blobNovember 30

    Anyone know an easy way to convert clob data to blob data? We upgraded a client to 8.1.7.2 and now we can no longer store MS-Word templates to the RDBMS. I deduce this is because MS-Word templates are binary files. Earlier versions of 8.1.7 and 8.1.6

  • Error when Converts rows to columns dynamically in clob data typeNovember 30

    Hi I am using below pl/sql statement SELECT NO, MAX (DECODE (NAME, 'A', VALUE1, NULL)) AS A, MAX (DECODE (NAME, 'B', VALUE1, NULL)) AS B, MAX (DECODE (NAME, 'C, VALUE1, NULL)) AS C, MAX (DECODE (NAME, 'D', VALUE1, NULL)) AS D FROM ( SELECT NO, RTRIM

  • Optimize a data parser that converts CLOB into tableNovember 30

    I am importing complex array data from Cold Fusion into ORACLE using a stored procedure. What I've done is convert the data into a CLOB, pass it into ORACLE, then parse it into a temporary table using a pipelined function. Unfortunately the array is

  • How to convert BLOB data into string format.October 11

    Hi, I have problem while converting blob data into string format. for example, Select dbms_lob.substr(c.shape.Get_wkb(),4000,1) from geotable c will get me the first 4000 byte of BLOB . When i using SQL as i did above,the max length is 4000, but i ca

  • Convert clob to xmltypeNovember 30

    Hi How to convert data CLOB datatype to XMLTYPE Datatype Ex: field col1 has clob data type any possible to convert col1 in target table col1 xmltype datatype Regards, VenkatHi Venkat, Please try the following: CREATE TABLE CLOBTABLE ( CLOBCOL1 CLOB I

  • Convert clob to string?November 30

    hi all, i'm having a problem getting the returnvalue of a storedproc. i'm using oracle database and created an oracle function that returns a clob data. unfortunately in vb.net, it won't accept clob format. if i change the returnvalue to varchar2 for

  • How to convert CLOB to varchar2 whose length is more than 4000November 30

    Hi , I have to retrive the CLOB data into varchar2 and spilt those comma seperated values into rows but i am getting following error " ORA-06502: PL/SQL: numeric or value error: character string buffer too small " the proc i used is like followi

  • How to convert clob to varchar2 in an update triggerNovember 30

    Hi, I need to convert a field (clob) to varchar2 in a update trigger, how can I do that? regards.The maximum amount of data you can store in CLOB column is 4GB. You have table TABLE1 having col1 CLOB datatype.You have one more table Table_audit_1 wit

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.776 s.