Re: How to invoke Windows SQL command from a batch file?

srini wrote:

> sqlplus srini/srini_at_srini
> select bytes/power(1024,3) from dba_segments where
> segment_name='ATTACHMENTS_BLOB';

1. Put the SQL query into a file (called, for example, foo.sql).
2. Edit your batch file to look like this:

     sqlplus srini/srini_at_srini @foo.sql

3. Read the SQL*Plus manual.

• Phil