Solve : OSQL command?

1.	Solve : OSQL command?
Answer» 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/[emailprotected] @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

Discussion