0
In the system has a variable vsoma which shall receive the total sum of the column Values.
How can I assign the sum value SELECT sum(valor) from PRODUTOS2?
1 answer
2
Use the clause INTO :
Example:
SELECT sum(COLUNA) INTO VARIAVEL from TABELA
The sum result will be assigned to the variable you declared.
More information:
Browser other questions tagged oracle pl-sql
You are not signed in. Login or sign up in order to post.
SELECT sum(valor) INTO VARIABLE from PRODUTOS2– Don't Panic
In the system? I believe it is just to make the connection to the BD where the query will be, getting the return just play inside the variable.
– EmanuelF
@Everson plays as answer :P
– rLinhares
@rLaws Done! D
– Don't Panic