Orcale存储过程for语句用法，并且每500条提交一次。 create or replace procedure PS_TEST IS begin        FOR i IN 1..10000        LOOP          --delete from test where name=to_char(i);        INSERT INTO test VALUE

select trunc(sysdate,'mm') from dual;

create sequence seq_logger minvalue 1 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20;

create table logger(task_id number(10) not null,task_name varchar2(30),table_name varchar2(30),task_sign varchar2(200),start_time date,end_time date,task_log varchar2(200),task_pos varchar2(50),task_s

UNION 操作符用于合并两个或多个 SELECT 语句的结果集。 请注意，UNION 内部的 SELECT 语句必须拥有相同数量的列。列也必须拥有相似的数据类型。同时，每条 SELECT 语句中的列的顺序必须相同。 create table test1(id integer, name varchar2(20), age integer); insert into test1 valu

drop table test1; drop table test2; delete from test1; delete from test2; create table test1(id integer, name varchar2(20), score integer, stat_date varchar2(8)); insert into test1 values(1,'

create or replace procedure sp_loggger(oi_task_id in out integer,ii_task_status in integer,iv_task_name in varchar2,iv_table_name in varchar2,iv_task_sign in varchar2,iv_task_log in varchar2,iv_task_p

create or replace procedure 存储过程名称(iv_date   in varchar2,oi_return out integer) is vi_task_id    integer; vv_task_name  varchar2(30); vv_table_name varchar2(30); vv_task_pos  varchar2(50); vi_result i

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions002.htm

v_name varchar2(20); select *from emp ename like '%'||v_name||'%';

1.新建type strcat_type create or replace type strcat_type as object  (        cat_string varchar2(4000),             --对象初始化        static function odciaggregateinitialize(cs_ctx in out strcat_typ