Substitution Strings in APEX

Oracle Application Express is a rapid development tool for Web applications on the Oracle database.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Substitution Strings in APEX

Post by admin »

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
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests