Returning COUNT() as a variable
I have read a number of documents on this topic and I don't think I have anything that works.
Here is one variation:
SELECT COUNT(*) FROM Invoices01 INTO @V1;
Idea is I could check @V1 to see how big it is.
But I don't think this is working properly. Its part of a stored procedure.
Is this good code?
Mike
Subject
Written By
Posted
Returning COUNT() as a variable
March 26, 2023 03:52PM
Sorry, only registered users may post in this forum.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.