SQL*Plus Questions

I was wondering if anyone had any SQL*Plus sites marked (examples, tutorials, etc).

I'm also wondering if there's a way in a .sql file to turn off the screen "echo" during a SPOOL. I have some .sql files that generate several thousand records and it seems like if it wasn't updating the SQL*Plus window with each record and only dumping to the txt file it would run much faster.

Any tips, example, or anything else on SQL*Plus or SQL in general I would appreciate.

... I'm digging through all the forum posts and such now.

Thanks!

Hello;

got the following from a web site about sql*plus:

To spool output generated by commands in a command file without displaying the output on the screen, use SET TERMOUT OFF. SET TERMOUT OFF does not affect output from commands run interactively.

here is the link:

http://rfhs8012.fh-regensburg.de/~or....html#off87240

cheers