Thursday, April 30, 2020

Validate the given field is Number or Varchar only

Select sysdate from dual where DECODE(REGEXP_INSTR (field, '[^[:digit:]]'),0,'NUMBER','NOT_NUMBER')='NOT_NUMBER'

this query will help to validate the given field is number or not
- No comments:
Subscribe to: Comments (Atom)

Customer Credit Card Query

 select hca.cust_account_id,        hca.party_id,        hcas.party_site_id,        site_use_id,        hcsu.org_id,        hca.account_numb...