If those two views hold the answer, then I haven't a clue what the question is.

You might be looking for CASE http://download-west.oracle.com/docs...5a.htm#1033394