SQL & PL/SQL

Hi All,

I've executed SQL through Batch Files before but I'm a little stumped with executing the sql with parameters. So for instance I have a sql file called:

insert.sql

Insert into TableA
 select * from TableB
 where service_dt >= '&&x_start_dt' and service_dt <= '&&x_end_dt';

I can execute this without problems normally but including the substitution variables in the batch (.bat) file called Execute_insert.cmd is a bit troublesome...I've played around with it and can't get it to work.

Any help would be appreciated.

Thanks,
Ed