tag:blogger.com,1999:blog-8873109125023142810.post7876648759776737256..comments2024-03-29T06:56:24.360+05:30Comments on Let's Develop in Oracle: Extracting text between html tags (removing html tags)Nimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-8873109125023142810.post-36219924660669824022021-07-06T16:36:12.277+05:302021-07-06T16:36:12.277+05:30I really loved reading your blog. It was very well...I really loved reading your blog. It was very well authored and easy to undertand. Unlike additional blogs I have read which are really not tht good. I also found your posts very interesting. In fact after reading, I had to go show it to my friend and he ejoyed it as well! <a href="https://htmlmailto.com" rel="nofollow">html email link</a>Jamesyhttps://www.blogger.com/profile/17753362323285152901noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-14760712044419617062020-07-19T09:49:43.687+05:302020-07-19T09:49:43.687+05:30Good article, please check my blog for more fusion...Good article, please check my blog for more fusion hcm topics in detail <br />https://www.oraclefusionhcm.comAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-81591862950362870582018-03-13T03:04:30.059+05:302018-03-13T03:04:30.059+05:30bookmarked!!, I like your web site!bookmarked!!, I like your web site!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-11067902478836888812016-06-02T21:58:52.661+05:302016-06-02T21:58:52.661+05:30nice solution. thx!nice solution. thx!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-8681407946456199742016-02-18T15:00:12.245+05:302016-02-18T15:00:12.245+05:30Hi Nimish,
can you pls help with a query to extr...Hi Nimish,<br /><br /> can you pls help with a query to extract following tags th attributes or table border=2 from the DB ColumnAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-89293800317045127122015-03-25T03:58:57.990+05:302015-03-25T03:58:57.990+05:30Hi..can you help me with same query in SQL.Hi..can you help me with same query in SQL.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-87856956989568140972014-02-14T08:32:56.890+05:302014-02-14T08:32:56.890+05:30thanks, this is much appreciated!thanks, this is much appreciated!Anonymoushttps://www.blogger.com/profile/09247601786616464153noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-52745245532042120062014-02-12T13:05:19.484+05:302014-02-12T13:05:19.484+05:30use translate
translate('<Nimish>Hello&l...use translate<br />translate('<Nimish>Hello<Garg>','<>','[]')Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-72253267622522580492014-02-12T05:32:41.366+05:302014-02-12T05:32:41.366+05:30Hi Nimish, I have similar issue, I'd like to r...Hi Nimish, I have similar issue, I'd like to replace pointy brackets with square brackets.<br /><br />FROM: text text text text text<br />TO: text text text [BACKSPACE] text text<br /><br />Thanks,<br />TomAnonymoushttps://www.blogger.com/profile/09247601786616464153noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-71429492409400442342014-02-11T11:28:19.227+05:302014-02-11T11:28:19.227+05:30i did not get your issue. Please provide input str...i did not get your issue. Please provide input string and output dataNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-22564289710216173082014-02-11T10:48:04.348+05:302014-02-11T10:48:04.348+05:30how abaut if i want select between ( and ) tags. i...how abaut if i want select between ( and ) tags. i try replace < with ( and > with ) it did not work Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-30829796308321503902013-06-18T18:52:17.993+05:302013-06-18T18:52:17.993+05:30Yes you can do soYes you can do soNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-75755949337790862332013-06-18T17:24:17.502+05:302013-06-18T17:24:17.502+05:30Hi there ,
Its pretty nice blog in there . Howeve...Hi there ,<br /><br />Its pretty nice blog in there . However I wanted to ask if i can use the same on a column inside a table say Projects_Projects so that the whole column is stripped off html tags without updating the data in the table .The main purpose being the data needs to be displayed in the report generated from the database JJhttps://www.blogger.com/profile/18349728473414924433noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-45767366740318357922011-12-21T20:55:13.674+05:302011-12-21T20:55:13.674+05:30thank buddy :)thank buddy :)Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-18757743966450536412011-12-21T18:07:43.077+05:302011-12-21T18:07:43.077+05:30Great blog.The code is good and easy to understand...Great blog.The code is good and easy to understandable.It help to extract between HTML tags.Thanks for wonderful posting.Joomla Developerhttp://www.joomla-web-developer.comnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-14799424732773982432011-10-14T12:07:45.214+05:302011-10-14T12:07:45.214+05:30Thanks for pointing this out :)Thanks for pointing this out :)Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-9765584202230261382011-10-08T03:28:20.577+05:302011-10-08T03:28:20.577+05:30The 11G example appears to work in 10g (10.2.0.5)....The 11G example appears to work in 10g (10.2.0.5).Anonymousnoreply@blogger.com