Monday, October 23, 2017

How to generate Random Number in given Range

SELECT FLOOR (DBMS_RANDOM.VALUE (1, 100))
  FROM DUAL;

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)