2014年1月20日
常用Oracle SQL
摘要： 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 阅读全文
posted @ 2014-01-20 15:40 taoliuhua 阅读(183) 评论(0) 推荐(0)
Oracle 使用 execute immediate 不能赋值问题
摘要： 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 阅读全文
posted @ 2014-01-20 15:38 taoliuhua 阅读(484) 评论(0) 推荐(0)