Currently in my company i have to follow these steps....
Login to the server using putty client on ssh, using username and password of server.
type "sqlplus" to enter into oracle db.
Run query ex:(select * from f_table where table.p.time > yesterday_date and table.p.time <= today_date;).
Output result save in putty output logs on my pc.
Want i want is this.... I want to build a application in visual basic that connect to server and then database using user/pass of both server(using ssh) and oracle db(using db username/password) and sql query run automatically on DB and return the output into a log file in my pc.
..........
is this possible or how much of this possible...... i have expertise in Visual studio and always prefer visual basic programming......
Thanks in Advance....