| 1013 | Apex - General - Items used in PL/SQL | Code | S_DATE_FORMAT'
, 'APP_NLS_TIMESTAMP_FORMAT'
, 'APP_NLS_TIMESTAMP_TZ_FORMAT'
, 'APP_IMAGES'
, 'APP_PAGE_ID'
, 'APP_SESSION'
, 'SESSION' -- is an alias of APP_SESSION
, 'APP_SESSION_VISIBLE'
, 'APP_UNIQUE_PAGE_ID'
, 'APP_USER'
|
| 1021 | Apex - Lists - Hierarchy | Info | />
f?p=&APP_ID.:1000:&SESSION.::&DEBUG.::::<br/>
and<br/>
javascript:window.open('f?p=1234:1000:&APP_SESSION.::', '_blank')<br/>
<br/>
Note that the query does not take the application_id into account - shouldn't be a problem in most cases. |
| 1029 | Apex - Session State - About Session State | Current Session ID | Get the current session id using something like this:
<textarea class="textarea codemirror-sql">select v('APP_SESSION') from dual;</textarea> |
| 1029 | Apex - Session State - About Session State | v('SESSION') not null | When using v('SESSION') or v('APP_SESSION') outside of Apex, you would expect these to be null on every occasion. Turns out they aren't - well, not always anyway. May have something to do with shared server processes - seems logical, since connections are re-used in that sort of setup - but I'm not sure.<br/>
<br/>
The solution is quite simple. T |
| 1029 | Apex - Session State - About Session State | Code | d.item_id = i.item_id (+)' || c_lf
|| 'and d.item_id = pi.item_id (+)' || c_lf
|| 'and d.flow_instance = ' || nvl(p_session_id, 'v(''APP_SESSION'')') || ' -- your session ID' || c_lf
|| 'and d.flow_id not between 4000 and 4999 -- ignore dev builder et al' || c_lf
|| 'order by |
| 1073 | Miscellaneous - VMware | My VMware setup | s VM's as well; I do 90% of my daily work on one of those via Remote Desktop. And an OpenVPN Access Server Virtual Appliance takes care of VPN access (<a href="f?p=&APP_ID.:1064:&APP_SESSION.">more info</a>).<br/>
A highly recommended setup; it has been extremely reliable since I installed all that in 2013.<br/>
<br/>
And to |
| 1078 | Miscellaneous - Links | Codemirror - Syntax Highlighting | ;
Apex 5 – Region with syntax highlighting</a>.<br/>
<br/>
My own Codemirror implementation and upgrade notes can be found <a href="f?p=&APP_ID.:1086:&APP_SESSION.">here</a>. |
| 1079 | DBA - Package Dependencies 1 | Info | Packages and the tables & columns they reference, take 1. Click <a href="f?p=&APP_ID.:1081:&APP_SESSION.">here</a> for take 2.<br/>
<br/>
A method to find out which packages reference which columns. It's not always perfect (because it uses text matching it tends to find too much), but I have found it to be very useful when tryi |
| 1080 | (PL)SQL - Dbms_metadata | ORA-31603 | in the view sources, and I tried to avoid the text column (which is of type long). As an alternative, using the "long to clob" function described <a href="f?p=&APP_ID.:1026:&APP_SESSION.">here</a> you could do something like this:
<textarea class="textarea codemirror-sql">select a.*
from
(
select v.*
, tedstruik.ted_p1026.column |
| 1081 | DBA - Package Dependencies 2 | Info | Packages and the tables & columns they reference, take 2. Click <a href="f?p=&APP_ID.:1079:&APP_SESSION.">here</a> for take 1.<br/>
<br/>
A second method to find out which packages reference which columns. This one uses the elegant "dba_dependency_columns" method presented by <a href="http://rwijk |