Forgive me if this has been previously addressed; I could not find a forum search form (EDIT: oddly, one showed up AFTER I posted but was not there bwfore…?).
I have just started using both TDA and PL/SQL. My experience up to now has been T-SQL and Microsoft Query.
I have created a PL/SQL query in our Toad (2.1) environment and it runs successfully, returning exactly what I expect. However, there are repeated segments that could best be handled using variables.
Problem is, I cannot get common syntax to work. Variables seem to be DECLAREd okay but fail when I try to assign a value; I receive a syntax error at the := operator.
Are PL/SQL variables just not supported, or is my noobness showing?
EDIT: the code structure others have provided from similar questions (DECLARE then BEGIN/END;) is not working and I can’t figure out why not. No matter what I try I receive errors…
Message was edited by: fabricator_296