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

Oracle Standard Package for Order Totals

  Purpose: Sometimes we need to show line-wise or complete order totals (Basic / Tax / Tax+Basic) in reports. Oracle provides a standard...