Window | Backup | data database 2 days prior to meet a customer's Oracle SCO under automatic backup EXP Script problems, can't normal execution, if re-install Oracle need to prepare. But the backup can't delay, or database lost but trouble. And wanted to in the Windows client write a automatic backup Script to achieve timing automatic backup. But in the Windows down to the system time is "2004-11-25 Thursday" formats such as a file name I can't. So I went to the Internet looking for A, no results, had to give up, for a fixed the file name of the temporary use.
Over 2 days. Some information, finally have the results: in fact, DOS under character processing method, can be summarized as follows:
On this date format: "2004-11-25 on Thursday," the % DATE :~ 0,10% is getting the 2004-11-25
Note: The DATE for the system variables, "," said that starting with the front of the string "~ 0,10 "from 0th characters to take 10 characters.
Some similar Gee Basic under the SUBSTR () function, right?
Problem solving, under Windows writing a Shell Script is very useful, especially want to automatically backup.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
