tag:blogger.com,1999:blog-4007772006737635792.post5026697101304486736..comments2024-03-27T16:11:52.332+05:30Comments on Shyam's Blog | Oracle Cloud, Peoplesoft, Workday: Oracle Operator - REGEXP_LIKEShyamhttp://www.blogger.com/profile/08146888311621138779noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-4007772006737635792.post-61244590857136059402014-07-10T02:29:08.877+05:302014-07-10T02:29:08.877+05:30How to use REGEXP_LIKE in PS QueryHow to use REGEXP_LIKE in PS QueryAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-71233925259965743482011-01-20T14:15:09.998+05:302011-01-20T14:15:09.998+05:30number of options available with the use of this o...number of options available with the use of this operator here: http://psoug.org/reference/regexp.htmlShyamhttps://www.blogger.com/profile/08146888311621138779noreply@blogger.comtag:blogger.com,1999:blog-4007772006737635792.post-57748251413842986052011-01-20T12:15:58.564+05:302011-01-20T12:15:58.564+05:30Hi Shyam
I had a scenario, where I should insert ...Hi Shyam<br /><br />I had a scenario, where I should insert numbers onto a varchar field, but it should only have numbers and not alphabets. <br /><br />Creating a constraint with REGEXP as follows helped me out.<br /><br />CREATE TABLE test(column1 varchar(200) CHECK (REGEXP_LIKE (column1, '^[[:digit:]]+$')));<br /><br />Thanks a lot for your post on REGEXP which helped me to get this done :)<br /><br />Cheers<br />YamunaYamuna Srinoreply@blogger.com