oracle - 在 SQL Server 中有一个我想在 Oracle 中复制的计数器

Question

谁能提供Oracle的代码语法？我附上了 SQL Server 代码

DECLARE @count1 INT

SELECT @count1 = (SELECT COUNT(*) AS processgroupcount 
                  FROM mpp.processgroup 
                  WHERE loc = '1' AND bk = '1' AND bk_yr = '2019')

PRINT 'PROCESSGROUP RECORDS in GEN5 for loc 1, bk 1, bk_yr 2019'
PRINT @count1

标签： oracleplsql

Answer 1

DECLARE
  COUNT1 NUMBER;
BEGIN
  SELECT COUNT(*)
    INTO COUNT1
    FROM MPP.PROCESSGROUP
   WHERE LOC = '1'
     AND BK = '1'
     AND BK_YR = '2019';
  DBMS_OUTPUT.PUT_LINE('PROCESSGROUP RECORDS IN GEN5 FOR LOC 1, BK 1, BK_YR 2019');
  DBMS_OUTPUT.PUT_LINE(COUNT1);
END;