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
Thursday, April 30, 2020
Subscribe to:
Posts (Atom)
-
Here the article will describe about how to register WebADI to Responsibility menu Go to System Administrator --> Security --> Respo... -
1. To download Ldt file for a Concurent Program FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_nam...
-
using the below query can check the invoice status. SELECT DECODE(AP_INVOICES_UTILITY_PKG.GET_APPROVAL_STATUS(AIA.INVOICE_...