I would like to declare and display a variable in Oracle.
In T-SQL I would do something like this
DECLARE @A VARCHAR(10) --Declares @A SELECT @A = '12' --Assigns @A SELECT @A --Displays @A
How can I do this in Oracle.