Using sql statements in file

Hi,

I would like to do the following using files:

1. put create database, create tables sql statements in a file and execute through prompt

2. insert or update data that is put in a file

Please let me know if there are any examples that lists how sql statements can be  put in a file and used.

Thanks

Suresh Basandra