OSQL command

i want to create a database using the OSQL command, but using a batch file and not on command prompt...


Please help

u can use this command in the bat file

sqlplus username/Password@databasename @sqlfile.sql >>lg.log

where sqlfile is the file where u store the script u want to execute
and lg.log is where the sql loc commints and errors will be.

also if u want to get the out put of an select statment as eg
u can use the sql command spool spoolfile.txt before the select (in the sqlfile)and next it put
spool off like this

set linesize 600
spool a.txt
select 1 from dual;
spool off

hope its usful for u