摘要:
beginfor cc in ( select t.yskid , t.xuh, row_number() OVER(PARTITION BY t.yskid order by t.yssjid ) as row_flg ,rowid from yuansbxsj t ) loop update y 阅读全文
摘要:
ALTER procedure [dbo].[SP_splitpage]( @sql nvarchar(4000), --要执行的sql语句 @currentpage int=1, --要显示的页码 @pagesize int=50 --每页的大小)asbegin set nocount on de 阅读全文
摘要:
--1、找到自己执行update语句的时间select r.FIRST_LOAD_TIME,r.* from v$sqlarea r where sql_text like '%update yzxdcfmx a set a.neir=(select%' order by r.FIRST_LOAD_ 阅读全文
摘要:
create or replace function getDateDuan(vChuSSJ varchar2,aFlag varchar2) return integer as vDate date; p_nl_str varchar2(20); p_nl_s number; p_nl_y num 阅读全文