with sqlplus for oracle you can do:

shell>sqlplus username/password @filename_with_sql.sql


where filename_with_sql.sql looks like this for example:
------------------------------------------
select * from v$database;
quit
-------------------------------------------

/Peter