Query to find if we are connected to Run or Patch Database Edition on EBS12.2

In Oracle Apps R12.2 if we want to determine that database connection is to run or patch edition. The below query can help you to get the answer

Query:

SQL> select ad_zd.get_edition_type from dual;
GET_EDITION_TYPE
--------------------------------------------------------------------------------
RUN







If you like please follow and comment