oracl 数据库中查询当前时间前几天的数据

女爷i 2022-01-13 11:23 283阅读 0赞

[2019独角兽企业重金招聘Python工程师标准>>> ][2019_Python_] ![hot3.png][]

CREATE OR REPLACE PROCEDURE ecd_b2a_get_pass_data_bank(
      bankId IN VARCHAR2,
      beginDay IN NUMBER,
      endDay IN NUMBER,
      
      b2aNo OUT VARCHAR2,
      accId OUT VARCHAR2,
      b2aType OUT VARCHAR2,
      b2aWay OUT VARCHAR2,
      b2aOrder OUT VARCHAR2,
      b2aName OUT VARCHAR2,
      b2aBank OUT VARCHAR2,
      b2aAmount OUT NUMBER,
      b2aRemaining OUT NUMBER,
      b2aReturnUrl OUT VARCHAR2,
      b2aNotifyUrl OUT VARCHAR2,
      b2aNotify OUT CHAR,
      b2aState OUT CHAR,
      b2aCheck OUT CHAR,
      b2aDate OUT TIMESTAMP,
      b2aDateNotify OUT TIMESTAMP,
      b2aDateCheck OUT TIMESTAMP,
      b2aOperator OUT VARCHAR2,
      b2aRemark OUT VARCHAR
    )
    IS
    BEGIN
      SELECT
         B2A_NO, ACC_ID, B2A_TYPE, B2A_WAY, B2A_ORDER, B2A_NAME, B2A_BANK, B2A_AMOUNT,B2A_REMAINING,
         B2A_RETURN_URL, B2A_NOTIFY_URL, B2A_NOTIFY, B2A_STATE, B2A_CHECK,
         B2A_DATE, B2A_DATE_NOTIFY, B2A_DATE_CHECK, B2A_OPERATOR, B2A_REMARK
      INTO
          b2aNo,accId,b2aType,b2aWay,b2aOrder,b2aName,b2aBank,b2aAmount,b2aRemaining,b2aReturnUrl,b2aNotifyUrl,
          b2aNotify,b2aState,b2aCheck,b2aDate,b2aDateNotify,b2aDateCheck,b2aOperator,b2aRemark
      FROM t_b2a b2a
      WHERE 
       b2a.B2a_Bank = bankId   
       AND b2a.B2a_Date BETWEEN sysdate-beginDay AND sysdate-endDay;
    
       EXCEPTION
         WHEN NO_DATA_FOUND THEN
           NULL;
         WHEN OTHERS THEN
           RAISE;
    END ecd_b2a_get_pass_data_bank;

转载于:https://my.oschina.net/u/3647620/blog/1552562

[2019_Python_]: https://my.oschina.net/u/2663968/blog/3061697
[hot3.png]: /images/20220113/1f5ce6e16d5247a1b7b1117d6b049837.png