Data marts and data warehouses are not BI/DSS systems per se, but are rather major core components of the BI/DSS infrastructure that drive business applic…

Today, the term Business Intelligence (BI) is used synonymously with Decision Support System (DSS), which is an organized collection of people, compute…

/* the next two queries help you find out other objects you own.        */ /* use this query to find out what procedures, functions, and triggers */ /* yo…

In order to access DD tables that begin with “DBA_”, your userid would need to have been granted the DBA role.  Output displayed in the examples below wi…

REM REM Calculates average row size in a table REM PROMPT PROMPT AVERAGE ROW SIZE IN A TABLE PROMPT ACCEPT towner PROMPT 'Table owner name: ' …