My goal is to create a fast refreshable materialized view (MV) that holds all the combinations of records in specific related tables. So also the 'incomplete combinations'. So the query that is needed contains a full outer join. First a disclaimer about using LiveSQL. I tried but...

I’m using a Polymorphic Table Function (PTF) and adding a new column TIMESTAMP_CALCULATED of type TIMESTAMP with fractional seconds scale 9. In FETCH_ROWS I populate it with a constant value: 2026-01-01 01:01:01.123456789 However, when selecting the PTF output, the value appears ...

Hi all, I have a hierarchy between levels in my_hierarchy table (between id_lvl and id_lvl_sup). Each level (lvl) may have items (id_item), and each item has a category (id_item_sup). These data is stored in my_items table. Now I want to build a report based on the my_view view. ...

Hi Tom, I got a Web Form that is able to display data to users and read user input back into the database. It is very important to be able to read user input back into the database. This is why I did not use out-of-the-box solutions like "owa_utils.read SQL into table". However, ...

I would like to be able to analyze large PL/SQL code base to identify internal PL/SQL subprograms called in PL/SQL application code. I know that I can get package level dependencies with DBA_DEPENDENCIES and that PL/Scope should give subprograms level information. But I cannot ma...