Hello,

I like the DBI shell, too. Provides a consistent interface to all kinds of databases.

For long queries, I put them in a file and then do:

USER@dbi:Oracle:SID> /run /path/to/file.sql

This will run the query in the file and show the resultset on the terminal.

regards,