SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use SQL query result in DOS commands

662374Oct 26 2010 — edited Oct 28 2010

Hi

Currently i am runnig below DOS commands manually
d:\apps\bin>TrueGridsCalc period="Aug 2010"

Now I want to write one batch file and schedule job on windows and make value of "period" to be dynamic. So to get that value i need to fetch it from DB

Steps which i am taking are
1. connect DB from command line (using SQLPLUS)
2. run query to fetch result
3.How to use query result in "period" parameter ?

I am good at step 1 and 2. Dnt know how to use query result in command to make it dynamic

Thank you
Sachin

Edited by: sachin.mali on Oct 26, 2010 4:39 PM

Edited by: sachin.mali on Oct 26, 2010 4:43 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 25 2010

Added on Oct 26 2010

7 comments

1,057 views