Hacoonar's

--drop table REPORT_LOG cascade constraints;/*==============================================================*//* Table: REPORT_LOG *//*==============...

/*创建其他存储过程*/procedure genProc(vWhere in varchar2) isbegin v_str = 'create or replace ...'; execute immediate v_str||vWhere;--执行拼串完成后的sqlend genProc; execute immediate 相当于“执行/编译”后面sql...

alter table COSTITLE modify TITLENAME VARCHAR2(40); 

TO_DATE格式(以时间:2007-11-02   13:45:25为例)           Year:              yy two digits 两位年                显示值:07        yyy three digits 三位年                显示值:007        yyyy four digits 四位年              ...