Filter varchar2 columns for date values only IMP for DFFs
Its helpful when date values only have to filter from DFF attributes.
As the attribute can have any data type value.
So if we use below where condition the future errors can be handled.
where
regexp_like (a.segment3, '[0-9]{4}/(0[0-9]|1[0-2])/([0- 2][0-9]|3[0-1])')
Its helpful when date values only have to filter from DFF attributes.
As the attribute can have any data type value.
So if we use below where condition the future errors can be handled.
where
regexp_like (a.segment3, '[0-9]{4}/(0[0-9]|1[0-2])/([0-
No comments:
Post a Comment