TO_NUMBER(REGEXP_SUBSTR(MY_COLUMN, '^\d+')) IS NULL
If the input is empty, it will return
null
. When will the input be empty? If the cell is a not number-only string.
According to The Directive 2009/24/EC of the European Parliament and of the Council, and Sec.103(f) of the DMCA (17 U.S.C. § 1201 (f)), the reverse engineering act committed to creating these blog posts is considered legal, as this is an original attempt to improve interoperability, and cannot be waived by license agreements.
The views expressed on this blog are my own and do not necessarily reflect the views of my past and present employers.
TO_NUMBER(REGEXP_SUBSTR(MY_COLUMN, '^\d+')) IS NULL
null
. When will the input be empty? If the cell is a not number-only string.
No comments :
Post a Comment