Few books on the market today go beyond discussing syntax and the barest rudiments of using Oracle SQL. This book changes that. The authors cover the full range of Oracle SQL features that apply to query writing. Learn to write UNION queries that take full advantage of SQL's set orientation, and ways to use Oracle's new analytic SQL features to write ranking queries, lag and lead queries, and more.