regular expression (merged) [message #395179] |
Tue, 31 March 2009 10:06  |
|
Hi All,
I have column (column_e) which have data like is as
FY2006 Q1T-I Quarter
FY2006 Q2T-I Quarter
FY2006 Q3T-I Quarter
FY2006 Q4T-I Quarter
FY2007 Q1T-I Quarter
FY2007 Q2T-I Quarter
Now i would like to search all rows in table where column_e value start with FY after four digit then one space then Q char after one number then T letter.
I have tried below but it is not working.could u please suggest the changes.
select * from dual where REGEXP_LIKE(trim('FY2006 Q1T-I Quarter'), '^FY[0-9]{4}[:space:]+Q[1-4]{1}T') ;
Thanks,
Sagar
|
|
|
|
|
|