How to get certain value using substitution strings,
Examples:
f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION.
the above is to create a URL and if you see &APP_PAGE_ID. will bring page ID and note the last dot must be there. In this URL 3 substitutions are there &APP_ID., &APP_PAGE_ID., &APP_SESSION.
Reference Type Syntax
Bind variable :APP_SESSION
PL/SQL V('APP_SESSION')
Short PL/SQL V('SESSION')
Substitution string &APP_SESSION.
1. APEX$ROW_NUM
2. APEX$ROW_SELECTOR
3. APEX$ROW_STATUS
4. APP_ID
5. APP_ALIAS
6. APP_DATE_TIME_FORMAT
7. APP_IMAGES
8. APP_NLS_DATE_FORMAT
9. APP_NLS_TIMESTAMP_FORMAT
10. APP_NLS_TIMESTAMP_TZ_FORMAT
11. APP_IMAGES
12. APP_PAGE_ID
13. APP_SESSION
14. APP_SESSION_VISIBLE
15. APP_UNIQUE_PAGE_ID
16. APP_USER
17. AUTHENTICATED_URL_PREFIX
18. BROWSER_LANGUAGE
19. CURRENT_PARENT_TAB_TEXT
20. DEBUG
21. HOME_LINK
22. IMAGE_PREFIX
23. LOGIN_URL
24. LOGOUT_URL
25. PRINTER_FRIENDLY
26. PROXY_SERVER
27. PUBLIC_URL_PREFIX
28. REQUEST
29. SCHEMA OWNER
30. SQLERRM
31. SYSDATE_YYYYMMDD
32. WORKSPACE_IMAGES
https://docs.oracle.com/database/121/HTMDB/concept_sub.htm#HTMDB03022
Substitution Strings in APEX
Substitution Strings in APEX
Malik Sikandar Hayat
admin@erpstuff.com
admin@erpstuff.com
Who is online
Users browsing this forum: No registered users and 50 guests