script to output table record info to a txt file
Posted on 2012-04-11
I have a table with 10 columns. One of the column is LAST_UPDATE ( data type--NUMBER) which contains data like --789451600.
There are about 60 rows in the table and this is the only column that gets updated in the table , say once every couple of hours.
I need a batch file/script that would get max value of the LAST_UPDATE column ,
check if there are any records other than the max(LAST_UPDATE) value in that column and
if there are any ,it should output those value(s) and its corresponding column values into a txt file to a specified folder.
This database is located on a Windows Server. The script/batch file will be executed using as a task scheduler job on a regular basis.
Please let me know if any further information is required.