Common Queries

Version 2

    Hello

    The provided TXT file contains a list of useful queries collected by a Blackboard Managed Hosting representative some time ago.

    On reviewing the list most of them should work while some will not.  Many of them are looking at tables within the BBLEARN_STATS (bb_bb60_stats) schema while some are looking at objects that are elsewhere. 

     

    Each query has a line comment line above it prefixed with -- to denote the title/description of what the query is providing.  Some queries have further notes spanning multiple lines to give more insight into how to use/edit the query.

     

    Note that I have not yet had a chance to test them all out so please use with caution.  If you feel like the query you are running is going to pull a large amount of data, use where rownum <= 10 at the end of your statement to limit your result set to 10 rows of data.

     

    If you spot any issues, have any successes stories or more you would like to submit please let us know.

     

    Cheers

    Joel