Search This Blog

Wednesday, November 20, 2019

Remove Special Character From A String Using REGEXP_REPLACE

SELECT REGEXP_REPLACE('test'dssdf/sdfs','[^a-z_A-Z ]') FROM DUAL

RESULT : testdssdfsdfs

No comments:

Post a Comment

Java to Oracle database Connection Using JDBC

Oracle database. // Java Program to Establish Connection  // in JDBC with Oracle Database // Importing database import java.sql.*; // Import...