-- Create a test table named createtablejob_table (run_datedate); -- create a stored procedure createorreplaceprocedurejob_procasbegininser
-- Create test table name create table job_table (run_date date); -- create or replace procedure job_proc
-- Create a test table name
Create table job_table (run_date date );
-- Create a stored procedure
Create or replace procedure job_proc
Begin
Insert into job_table (run_date) values (sysdate );
End;
-- Create a job and run it once every
--Create a test table name
CREATE TABLE job_table (run_date date);
--Create a stored procedure
Create or replace procedure Job_proc as
Begin
Insert into job_table (run_date) values (sysdate);
End
--Create a job and specify one minute
Here is the simplest test with Excel data.
1 Save Excel data as T.txt file, note file suffix named. txt
1 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
3 Jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2)Sql>
Here we use excel Data for the simplest test.
1) Save the excel data as a t.txt file. Note that the file suffix is. txt.
1 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
2 jhchen 11/07/2005 20:04:00 2005-11-7 20:04
3 jhchen 11/07/2005 20:04:00 2005-11-
Local Test Cases:
# there can be no spaces on either side of the equal sign, before the error has been out here
yesterday= ' date-d last-day +%y-%m-%d '
echo $yesterday
curday= ' Date +%y-%m-%d '
echo $curday
echo "Now time: ' Date ' +%y%m%d%T '"
LeadHttp caching mechanism as a Web performance optimization of the important means for the small partners engaged in web development is necessary to master the knowledge, but recently I met a few cache header settings related topics, found that
As database developers, we often face the task of finding and deleting redundant data in the database. if there is a large amount of redundant data in the database (as a percentage of the total ), the data accuracy and reliability will be affected,
File Access permission-detailed explanation of mode bit problems
I. Preface==========
This article describes how to set the access permissions for common files and directories in Linux. This article is written for beginners with a little
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.