Date * @param imonth * Number of years to increase or decrease */public static Date Addyear (date date, int iyear) {Calendar cd = Calendar.getinstance (); Cd.settime (date); Cd.add (Calendar.year, iyear); return Cd.gettime (); }/** * Transforms the Object type to date * @param date * @return */public static date Chgobject (object date) {if (date!=null Amp;date instanceof Date) {return (date) date; } if (date!=nullAmp;date instanceof String) {return dateutils.stringtodate ((String)
Label:Creating a Create script for an existing job in an Oracle database --generate a Create script for an existing job
Create or Replace procedureProc_generate_job_create_sql is
beginDbms_output. ENABLE (Buffer_size= NULL);--indicates that the output buffer is unrestrictedSys.dbms_output.put_line ('Declare'); Sys.dbms_output.put_line ('v_job number;'); Sys.dbms_output.put_line ('begin'); forJinch(SelectWhat, Interval fromuser_jobs) Loop Sys.dbms_output.put_line ('sys.dbms_job.submit (Job
First, the query performs the slowest SQLSELECT * FROM (select SA. Sql_text, SA. Sql_fulltext, SA. Executions "number of executions", round (SA. elapsed_time/1000000, 2) "Total execution time", round (SA. Elapsed_time/1000000/sa. Executions, 2) "Average execution time", Sa.command_type, SA. parsing_user_id "User ID", u.username "user name", SA. Hash_value from V$sqlarea sa left join all_users u on sa. parsing_user_id = u.user_i
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.