Peter Tury

If you were to log in, you'd be able to get more information on your fellow community member.

Static Page Comments

• June 12, 2002, on Style:

  The where clause is in two lines in the example above though the text suggests one line:
  "If it doesn't fit nicely on one line, give each clause a separate line:
  select *
  from news
  where sysdate > expiration_date
  and approved_p = 't'
  order by release_date desc, creation_date desc"
  In this case, one line would be the better, of course.