In pl-sql can I assign the SUM value to a variable?

Question

Navigation

#1 by (2 votes)

0

In the system you have a% variable of% that should receive the total value of the sum of the Values column.

How can I assign the sum value vsoma ?

oracle pl-sql

asked by anonymous 24.01.2018 / 14:10

1 answer

score 2 · Accepted Answer

2

Use the INTO clause:

Example:

SELECT sum(COLUNA) INTO VARIAVEL from TABELA

The result of the sum will be assigned in the variable you declared.

More information:

24.01.2018 / 14:20