Objective: I would like to write to the shell the process of collectively deleting old historical information after a certain period of time.
Conditions: Delete Generated 6 Months Before Current Time
The csv files are linked once a day.The csv file is registered in the GOODSTABLE table.I'd like to delete linked data from 6 months ago in the shell.
How to access the GOODSTABLE table from the shell and delete data from the shell
I looked into the method, but I couldn't find a way to delete it.I don't know how to execute the following conditions on the shell.
I think I need to check the sql value for the above conditions.
In that case,
Is it possible to write like above to access sql?postgresql shellscript
to_char is probably a function of Oracle, but it cannot be called directly from within the shell script.
I think you will just call the SQL program itself and receive its exit status and output results.
For example, with Oracle, you can use the SQL*Plus command to store the required results in shell variables.
© 2022 OneMinuteCode. All rights reserved.