Menu
  • HOME
  • TAGS

How to use SQL syntax in Oracle fast formula

oracle,performance,formula,oracle-apps

By looking at the function reference for OracleFormula, it seems that you have no other option than calling TO_CHAR with the appropriate format to achieve the desired result. based on the doc's example: mesg = 'Birthday is: ' + TO_CHAR (birthdate, 'DD') ...

Updating a contacts email and phone in Oracles HZ_CONTACT_POINTS through PL/SQL

oracle,plsql,oracle-apps

HZ_CONTACT_POINT_V2PUB is part of the interface for TCA. To quote from the TCA documentation: "Oracle Trading Community Architecture (TCA) is a data model that allows you to manage complex information about the parties, or customers, who belong to your commercial community, including organizations, locations, and the network of hierarchical relationships...