change to bash shell (much easier shell to work with)
terminal> bash
Startup sqlplus
terminal> sqlplus
You will be prompted for your username and password. Username is: yourmysqlusername@orcl10g2
Password is: pass1234
You will be prompted to change your password
Entering SQL
From the command prompt SQL> you can type any SQL statements. They must end in ';' to be executed.
To run a .sql file (eg create_grades.sql) from the prompt type:
SQL> @filename
eg if the filename was create_grades.sql:
SQL> @create_grades.sql
Remember the file that you wish to run must be located in the same directory on hobbes that you were in when you started sqlplus. If it's not you must include the path to the file in the command.