modernsky2003

摘要：set serveroutput on declare dbegin date; dend date; begin dbegin:=to_date('2008-04-16 00:00:00','yyyy-mm-dd hh24:mi:ss'); dend:=to_date('2008-04-16 23:59:59','yyyy-mm-dd hh24:mi:ss'); dbms_out... 阅读全文

摘要：http://www.cnblogs.com/dyj057/archive/2007/11/21/967826.html 阅读全文

摘要：1--------------/*操作表Users*/ create or REPLACE procedure userm_Users ( state varchar2, UserID rowID, UserAccount varchar2, UserName varchar2, Password varchar2, InsTime Date, LastActivityDate Date, St... 阅读全文

摘要：create or replace function GetDayName(theDate in varchar2) RETURN varchar2 is Result varchar2(64); BEGIN Result := substr(theDate,1, 4) + '年' + substr(theDate, 6, 2) + '月' + substr(theDate,9,... 阅读全文

摘要：SQLSERVER版本 CREATE VIEW StatusTable AS SELECT A.*,M.[MaTolID],D.[DeptName],G.[MaTolGrpName],D.[DeptID],G.[MaTolGrpID] FROM ( SELECT [status]= case [BaseState] when 'IDLE' then '空闲' w... 阅读全文