Huh, he'll drawn in the ocean! (i.e. the whole SQL Reference book).
"WITH" is used to emulate a table that, actually, doesn't exist. For example, I could do a simple example as follows: first create a table, insert some records into it, and - finally - select from the table: