SQLPLUS Question

I am new to Oracle transitioning from an Informix background. So, with that said please excuse this question if it sounds to simple.

Is there a way of executing sql statements from within a shell script without referencing an external sql file. For example, with Informix you can put the following in a shell script:

.
.

dbaccess dbname << EOF

   select * from mytable;
EOF
.
.

I would like to do something similar in Oracle.

Thanks,

Jorge :-) Received on Wed Jun 16 1999 - 17:08:27 CDT