'select <star>' also doesn't always do what you expect.

I recall a problem with some Oracle views that were based on 'select <star>' queries. What we didn't realize is that the '*' is evaluated when the view is compiled, and if you later add columns to the underlying tables the view did not automatically include them.

Edit: OK I don't know how to include a literal star in text here.