Just for the record (I know this is an old thread).

You can't do this in Oracle:

"select name, decode(total > 250, "pass","fail") status from student"

The syntax for the decode function is:

decode(...