What happened on 20.1 API references in oracle apex

Slit your string with APEX_STRING_UTL

Think you have a large text phrase and now you have to separate web addresses or email addresses or links or specific phrases from here. What you will do now?

Don't worry! In new release 20.1 of Apex API reference introduce APEX_STRING_UTL as extension of APEX_STRING to do such complex task easily. APEX_STRING_UTL has the following functions:

1. REPLACE_WHITESPACE Function
2. FIND_FILE_EXTENSION Function
3. FIND_PHRASE Function
4. FIND_PHRASES Function
5. FIND_EMAIL_ADDRESSES Function
6. FIND_EMAIL_FROM Function
7. FIND_EMAIL_SUBJECT Function
8. FIND_TAGS Function
9. FIND_LINKS Function
10. GET_DOMAIN Function
11. FIND_IDENTIFIERS Function
12. TO_DISPLAY_FILESIZE Function
13. TO_SLUG Function

Example 1:

select APEX_STRING_UTIL.TO_DISPLAY_FILESIZE(13312312) from dual;
-> 12.7MB

Example 2:

select APEX_STRING_UTIL.FIND_FILE_EXTENSION('foo.xlsx') from dual
-> xlsx

There are very effective functions in APEX_STRING_UTL are waiting for you.

Manage Interactive Grid with APEX_IG

This is also brand new API reference for Oracle Apex developers just like APEX_IR. By this package you will be able to add filter, delete saved report as well as clear or reset the IG report. APEX_IG has the following procedures and functions:

1. ADD_FILTER Procedure Signature 1
2. ADD_FILTER Procedure Signature 2
3. CHANGE_REPORT_OWNER Procedure
4. CLEAR_REPORT Procedure Signature 1
5. CLEAR_REPORT Procedure Signature 2
6. DELETE_REPORT Procedure
7. GET_LAST_VIEWED_REPORT_ID Function
8. RESET_REPORT Procedure Signature 1
9. RESET_REPORT Procedure Signature 2

Others update at 20.1

APEX_AUTHENTICATION is updated in this release with new PERSISTENT_COOKIES_ENABLED function and update of SEND_LOGIN_USERNAME_COOKIE.

APEX_JSON has added new function GET_CLOB_OUTPUT for returning temporary CLOB.

APEX_INSTANCE_ADMIN add some parameters to get and set more control on workspace, instance, password and admin password. Here is the following parameters.

1. WORKSPACE_NAME_USER_COOKIE
2. PASSWORD_NOT_LIKE_USERNAME
3. PASSWORD_NOT_LIKE_WORDS
4. PASSWORD_NOT_LIKE_WS_NAME
5. PASSWORD_ONE_ALPHA
6. PASSWORD_ONE_LOWER_CASE
7. PASSWORD_ONE_NUMERIC
8. PASSWORD_ONE_PUNCTUATION
9. PASSWORD_ONE_UPPER_CASE
10. SERVICE_ADMIN_PASSWORD_MIN_LENGTH
11. SERVICE_ADMIN_PASSWORD_NEW_DIFFERS_BY
12. SERVICE_ADMIN_PASSWORD_ONE_ALPHA
13. SERVICE_ADMIN_PASSWORD_ONE_NUMERIC
14. SERVICE_ADMIN_PASSWORD_ONE_PUNCTUATION
15. SERVICE_ADMIN_PASSWORD_ONE_UPPER_CASE
16. SERVICE_ADMIN_PASSWORD_ONE_LOWER_CASE
17. SERVICE_ADMIN_PASSWORD_NOT_LIKE_USERNAME
18. SERVICE_ADMIN_PASSWORD_NOT_LIKE_WS_NAME
19. SERVICE_ADMIN_PASSWORD_NOT_LIKE_WORDS

Deprecated and desupported at 20.1

You have to use OAUTH_AUTHENTICATE_CREDENTIAL intead of OAUTH_AUTHENTICATE Procedure Signature 2. Because OAUTH_AUTHENTICATE Procedure Signature 2 is deprecated from 20.1.

NB: You need minimum 20.1 version of Oracle Apex to run these API references. For more you can visit API documentation.

Think its help you. Good Luck.