prog:oracle_apex_show_my_user_information
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
prog:oracle_apex_show_my_user_information [2017/04/23 12:01] – angelegt gpipperr | prog:oracle_apex_show_my_user_information [2017/04/24 09:34] (aktuell) – gpipperr | ||
---|---|---|---|
Zeile 1: | Zeile 1: | ||
+ | =====Oracle Apex 5 - Wer bin ich? Dialog===== | ||
+ | |||
+ | **Ziel**: Info Dialog über den angemeldeten User und seine Rechte, den Status der Session und den Wert der Session Items der aktuellen Seite | ||
+ | |||
+ | |||
+ | PL/SQL Block für ein Region mit "PLSQL Content" | ||
+ | <code sql> | ||
+ | |||
+ | declare | ||
+ | |||
+ | cursor c_role(p_username varchar2) | ||
+ | | ||
+ | | ||
+ | , rtrim ( xmlagg (xmlelement (c, | ||
+ | from user_role_privs | ||
+ | where USERNAME=p_username | ||
+ | group by USERNAME; | ||
+ | |||
+ | begin | ||
+ | |||
+ | htp.p(' | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | |||
+ | htp.p(' | ||
+ | | ||
+ | | ||
+ | | ||
+ | for rec in c_role(p_username | ||
+ | loop | ||
+ | | ||
+ | end loop; | ||
+ | |||
+ | |||
+ | end; | ||
+ | |||
+ | </ | ||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
+ | |||
+ | Welchen Wert haben meine Page Items geraden: | ||
+ | |||
+ | <code sql> | ||
+ | select | ||
+ | , page_id | ||
+ | , item_name | ||
+ | , display_as | ||
+ | , component_comment | ||
+ | , apex_util.get_session_state(item_name) session_value | ||
+ | from apex_application_page_items | ||
+ | where application_id = :APP_ID | ||
+ | and | ||
+ | order by page_id, | ||
+ | </ | ||
+ | |||
+ | |||
+ | ---- | ||
+ | |||
+ | Informationen über meine Session: | ||
+ | <code sql> | ||
+ | begin | ||
+ | htp.p('< | ||
+ | | ||
+ | htp.p('< | ||
+ | htp.p('< | ||
+ | htp.p(' | ||
+ | htp.p('</ | ||
+ | htp.p('< | ||
+ | htp.p(SYS_CONTEXT(' | ||
+ | htp.p('</ | ||
+ | htp.p('</ | ||
+ | --- | ||
+ | htp.p('< | ||
+ | htp.p('< | ||
+ | htp.p(' | ||
+ | htp.p('</ | ||
+ | htp.p('< | ||
+ | htp.p(SYS_CONTEXT(' | ||
+ | htp.p('</ | ||
+ | htp.p('</ | ||
+ | --- | ||
+ | htp.p('< | ||
+ | htp.p('< | ||
+ | htp.p(' | ||
+ | htp.p('</ | ||
+ | htp.p('< | ||
+ | htp.p(SYS_CONTEXT(' | ||
+ | htp.p('</ | ||
+ | htp.p('</ | ||
+ | --- | ||
+ | htp.p('</ | ||
+ | --- | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | ---- | ||
+ | | ||
+ | | ||
+ | FOR i IN 1..APEX_APPLICATION.G_F01.COUNT LOOP | ||
+ | htp.p(' | ||
+ | END LOOP; | ||
+ | | ||
+ | | ||
+ | ---- | ||
+ | end; | ||
+ | </ |
prog/oracle_apex_show_my_user_information.txt · Zuletzt geändert: 2017/04/24 09:34 von gpipperr