摘要：
1.删除所有的表create or replace PROCEDURE SP_DROPTABLE(v_begintime in varchar2, v_endtime in varchar2)as v_tablename varchar2(256); cursor cur_tablename is select object_name from user_objects where object_type = 'TABLE' and to_char(CREATED, 'yyyy-mm-dd') between v_begintime and v_endtime 阅读全文
摘要：
create or replace procedure sp_page(AllCount OUT NUMBER, ResultSet OUT PagePack.PageCursor, PageCurrent IN NUMBER, PageSize IN NUMBER, Fields IN VARCHAR, Condition IN VARCHAR, OrderGroup IN VARCHAR, IsCount IN NUMBER) Authid Current_Useraspageindex number;psize number;sqlstr varchar2(1000);sqlcomm v 阅读全文