Skip to Main Content
Ted Struik - Oracle
Home
Ted Struik - Oracle
Search
Site Map
Statistics
Page Errors
Apex
General
Autocomplete
Conditions
Errors
Items used in PL/SQL
Validations
Dynamic Actions
Logs
Version
App-wide Items
Error Handling
Apex Views
Apex Upgrade
Database Dependencies
Show Source Code
URLs
Authorization
Modal Dialogs
Apex Office Print (AOP)
Reports
Checkboxes
Download
Errors
Nowrap Columns
Substitution Strings
Use IR results in pl/sql
Clickable Row
Row Highlight
Translate Filters etc.
Bar Charts
Column Usage
Reset Pagination
Hide IR Actions menu items
Interactive Grid
ORA-20987
ERR-1002
Copying Text
IG Info
Images & Fonts
Standard Icons & Fonts
WebDav
Font Awesome
Icons/image popup LOV
Lists
Hierarchy
LOVs
Definition Bug
Set 1-item LOV to Disabled
With Clause Errors
Modal LOV Plugin
HTML / CSS / JavaScript
Vertical Align
Legend CSS
Geolocation
Apex.confirm
Pie Charts
Codemirror
Theme Roller
Catching Key Strokes
Browser Cache
Locale
RequireJS
Import / Export
Dynamic Translations
Translated Pages
APEXExport
Component Settings
Charts
Translate Charts
[Reports] Bar Charts
Shuttles
Shuttle Sorting
Disable Shuttle Items
Menus
Accordion-Like
Scroll bug
Session State
About Session State
Rollback & Commit
Performance of v()
Apex Clone Session
Request
Collections
ORA-20101 & ORA-20104
ORA-00001
Max Row Count
(PL)SQL
External Tables
SQL Plus
Conditions
Long
ORDImage
Date & Timestamp
CGI environment
Sys_context
Rounding percentages
Apex_string.split in SQL
Dbms_metadata
Instr
Regular Expressions
Rollback to Savepoint
Use table aliases
(Pipelined) Bulk Collect
JSON
Source Code Search (PL/SQL)
Source Code Search (SQL)
Format Models
Pipelined Table Functions
Hint no_unnest
Listagg
DBA
Backup & Restore
Users
Export & Import
DBMS Jobs
Tablespaces
Table Size
Flush cache
Access Control List (ACL)
Locks
Java
Constraints
Object Dependencies
Package Dependencies 1
Package Dependencies 2
Grants
SQL History
Startup Errors
ORDS
Miscellaneous
Holidays
E-mail
NLExtract
Windows
VPN
VMware
Links
Google
Visualization Orgchart
Hide Search Results
Reverse Proxy
To-do List
Cytoscape
Graphics
Upscaling
Amazon Prices
Domoticz
DDoS
Hobbies
Motorcycles
'95 Kawasaki ZZR 600
'94 Kawasaki ZZR 1100
'91 Honda CBR 600 F2
'95 Kawasaki ZZR 1100
'99 Honda CBR 1100 XX
'00 Honda CBR 1100 XX
'02 Kawasaki ZX-12R (NL)
'05 Ducati 999 (NL)
'08 Honda Fireblade
'07 Suzuki Bandit 1250A
'18 Suzuki GSX-S 1000 F
MotoGP
Garfield
Lyrics
Skydive
Woodworking
Pantorouter
16 inch Bandsaw
Introduction
Frame
Wheels
Wheel mounts
Blade guides
Trunions and table
Enclosure
Alignment and more
Box Joint Jig
Foldable Sawhorses
Strip Sander XL
Photography
Sony RX10 IV
Search For
Hierarchy
Go
Rows
1
5
10
15
20
25
50
100
1000
All
Actions
Path Sort
Path Text
Entry Text
Display Sequence
Level
Entry Target
Page Id
->00010
->Home
Home
10
1
#
-
->00010->00011
->Home->Ted Struik - Oracle
Ted Struik - Oracle
11
2
f?p=&APP_ID.:1:&SESSION.::&DEBUG.::::
1
->00010->00012
->Home->Search
Search
12
2
f?p=&APP_ID.:2:&SESSION.::&DEBUG.:RP,RIR,CIR:::
2
->00010->00013
->Home->Site Map
Site Map
13
2
f?p=&APP_ID.:3:&SESSION.::&DEBUG.::::
3
->00010->00014
->Home->Statistics
Statistics
14
2
f?p=&APP_ID.:1113:&SESSION.::&DEBUG.::::
1113
->00010->00015
->Home->Page Errors
Page Errors
15
2
f?p=&APP_ID.:4:&SESSION.::&DEBUG.::::
4
->01000
->Apex
Apex
1000
1
#
-
->01000->01050
->Apex->General
General
1050
2
#
-
->01000->01050->01051
->Apex->General->Autocomplete
Autocomplete
1051
3
f?p=&APP_ID.:1011:&SESSION.::&DEBUG.::::
1011
->01000->01050->01052
->Apex->General->Conditions
Conditions
1052
3
f?p=&APP_ID.:1008:&SESSION.::&DEBUG.::::
1008
->01000->01050->01053
->Apex->General->Errors
Errors
1053
3
f?p=&APP_ID.:1012:&SESSION.::&DEBUG.::::
1012
->01000->01050->01054
->Apex->General->Items used in PL/SQL
Items used in PL/SQL
1054
3
f?p=&APP_ID.:1013:&SESSION.::&DEBUG.::::
1013
->01000->01050->01055
->Apex->General->Validations
Validations
1055
3
f?p=&APP_ID.:1019:&SESSION.::&DEBUG.::::
1019
->01000->01050->01057
->Apex->General->Dynamic Actions
Dynamic Actions
1057
3
f?p=&APP_ID.:1030:&SESSION.::&DEBUG.::::
1030
->01000->01050->01058
->Apex->General->Logs
Logs
1058
3
f?p=&APP_ID.:1031:&SESSION.::&DEBUG.::::
1031
1 - 15 of 189
Search
Info
Query to get a sorted list of the complete (root to child) path of an Apex list.
Code
Page
Name
Page ID
1021
Name
Apex - Lists - Hierarchy
Region
Identification
Sequence
10
Title
Hierarchy
Type
Interactive Report
Source
Source Type
DYNAMIC_QUERY
Region Source
select sys_connect_by_path(to_char(a.display_sequence,'fm00000'), '->') as path_sort , sys_connect_by_path(a.entry_text, '->') as path_text , a.entry_text , level , to_number( regexp_substr(a.entry_target, '[^:]+', 1, 2) ) as page_id , a.entry_target , a.display_sequence from apex_application_list_entries a where a.application_id = nvl(v('APP_ID'), 25384) and a.list_name = 'Navigation Menu' start with a.list_entry_parent_id is null connect by prior a.list_entry_id = a.list_entry_parent_id order by path_sort