title: Have a counter in SQL Server that I want to replicate in Oracle
body: <p>Can anyone provide the code syntax for Oracle? I have attached the SQL Server code</p>
  
  <pre><code>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
  </code></pre>