Ask Anantha

I googled for this and got this from some website. Do not remember the website from where I got this query. Thanks for the original author . Pasting the query for my personal records: SELECT owner,        table_name,        trunc(SUM(bytes) / 1024 / 1024) meg FROM   (SELECT segment_name table_name,                owner,                bytes         FROM   dba_segments         WHERE  segment_type = 'TABLE'         UNION ALL         SELECT i.table_name,                i.owner,                s.bytes         FROM   dba_indexes  i,                dba_segments s         WHERE  s.segment_name ...

This tip was posted in Oracle Apex Knowledge Group by Richard Martens. Its my sincere pleasure in thanking the author for this simple tip. The original blog is available here . I am posting the steps first, and a slight deviation which makes the setup one time only through this article. The idea is to create a region first and all sub-regions as tabs. If this design suits your application then its simple as copy-paste.Create a template Go to Shared Components  Navigate to Templates Press the Create Button Choose Region Choose From Scratch Provide the name jQuery Tabs Choose Custom 1 for template class Press Create button Once the template is created, find the jQuery tabs from the list and click to edit. Paste both the following codes in Definition Section: <div id="#REGION_STATIC_ID#" #REGION_ATTRIBUTES#> #BODY##SUB_REGION_HEADERS##SUB_REGIONS# <div style="clear:both;"></div> </div> <link rel="stylesheet" href=...

Oracle Application Express (APEX) offers a lot of regions to be displayed in a single page without cluttering the screen display. One such way of making a page to display lot of contents is using the Region Display Selector. In this tip however I am not going to show how to display the "Region Display Selector" but an inherent problem with this control. I have a screenshot of this control in action. I have Five regions in this sample page. For each region this "Display Selector creates a link in its control. As soon as you click a particular region, only that specific region will be displayed. The remaining will be hidden. The "drawback" is that there is no option to hide the first option "Show All". Initially when the page loads the "Show All" will be selected and all regions will be displayed. I think this should be a great feature which should be available in-built within Apex. But as of 4.2.3 version which I am using, this...