oracle - Use values from a sql query in batch script -


lets have query follows:

select name, age employee id=&id; 

is possible run query in batch file , use returned values in jscript inside batch script?

lets query returns "tom smith" name , "33" age.

its possible use values in batch script? if yes please can give me example?

i refering oracle database server.

it looks utility called sqlplus (command: sqlplus) available kind of thing.
see http://www.orafaq.com/wiki/sql
plus_faq

and how can create batch file sqlplus?

... can retrieve value environment variables using for :
for /f %%a in ('sqlplus ...') set ...


Comments

Popular posts from this blog

linux - Does gcc have any options to add version info in ELF binary file? -

android - send complex objects as post php java -

charts - What graph/dashboard product is facebook using in Dashboard: PUE & WUE -