Troublesome everybody prawn to help look at the following questions, thank you!

1. How to build a Job by a code, the Job every day from 8 to 20 points in each interval of 5 minutes to execute a stored procedure spjob1, this Job before 2019/10/15 to 2019/12/15 effective, best can give a correct example,

2. Oracle table, if one time columns need to be stored yyyy - - dd hh: mm mm: ss time, is to use the date data type?

CodePudding user response:

1, take a look at this
https://www.cnblogs.com/yx007/p/6519544.html
2, yes.

CodePudding user response:

Advice, don't use a string to storage time,

CodePudding user response:

Thanks for your help and advice.