FANDOM


Find all Banner APIs by tableEdit

This SQL will return all the tables for which an API is available.

SELECT owner,
       table_name,
       gb_common.F_GET_API_NAME(owner,table_name)

FROM   all_tables

WHERE  gb_common.F_GET_API_NAME(owner,table_name) IS NOT NULL;

Find a Banner API for a specific tableEdit

This SQL will return the API for a specific table, if any.

SELECT gb_common.F_GET_API_NAME('OWNER','TABLE_NAME')

FROM dual;

... where OWNER and TABLE_NAME are the desired values.

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.