Ask the Experts

Ask the Experts

Oracle and SQL

  • Resolving circular dependency between view and procedure

    I am receiving the errors "ORA-00604: error occurred at recursive level 1" and "ORA-01000: maximum open cursors exceeded." It appears as if I have a circular object dependency between a view and a procedure I created. I've been able to re-create a ...  Continue Reading

  • Dupes involving a compound key

    Suppose that there are two tables: TXN and TXN_DEAL. The latter is a child or sub-type table. TXN has five composite keys, which are repeated in the child table. I am trying to find multiple occurrences in child. In other words, I want to find TXN ...  Continue Reading

  • COUNT and MAX from unrelated tables

    I have two tables which are unrelated to each other. I want to do a count on one column in one table and max of one column in another table.  Continue Reading

  • Nth Saturday of the month

    Using the date functions, can I find out whether a particular date is the 1st, 2nd, 3rd, 4th or 5th Saturday of a month? Our leave rules have changed recently and I have to update my system to reflect full working on 1st, 3rd and 5th Saturdays, and ...  Continue Reading