Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

using regexp_replace to remove html tags and  

Gor_MahiaMar 10 2014 — edited Mar 11 2014

Hi,

I am trying to use regular expression to remove any html tags/  from a string replacing them with nothing as shown below,

sample= if i enter "hello to the world of<u><p><br>  apex whats coming up" i should get this==> "hello to the world of apex whats coming up"

consider query as, select regexp_replace(string, any html tags/ , 'i') from dual,


so how do i write the expression?

oracle 11g rel2,

thank you.
This post has been answered by KarK on Mar 11 2014
Jump to Answer

Comments

794117
Java/JSP = Server
javascript = client.

These things are not the same. They can not talk to one another.
This onclick event on the image runs on the client in javascript.
It can not invoke java/jsp code.

All Java/JSP code is executed. It produces an HTML page, which is sent to the client.
Then the client can run javascript, clicking buttons etc. No Java code (setting attributes etc) can be called.

The only communication javascript has with java is via submitting a form/request
ie nextpage.jsp?attr1=attrValue1&attr2=attrValue2
These parameters can only be strings.
There is no object communication between client and server - objects are stored on the server only.
intention is to have a column of buttons for a table, where a list is displayed. Upon clicking the button, the user will be provided with the details of the specific item
The correct way to do this would be to pass along an id identifying the item you want to display
eg Show Item details
Then in the showItem.jsp page retrieve an item using the parameter "56" and display its details.

Hope this helps,
evnafets


1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 8 2014
Added on Mar 10 2014
5 comments
36,295 views