'Job' Tag

• DBMS_JOB

  05月 30, 2009

  1、创建一张表 SQL> alter session set nls_language = american; Session altered. SQL> alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss'; Session altered. SQL> create table job_test ( job_date date); Table created. 2、创建一个过程 SQL> create or replace procedure p_job_test as   2  begin   3    insert into job_test values (sysdate);   4  end;   5  / Procedure created. [...]

  posted in Oracle 知识杂记 by | 编辑