I have a large question on PL/SQL as it is so different to T-SQL. That is the declaring of stored proecdure. How to retrieve dataset from Oracle by stored procedure?
For example: in T-SQL
create procedure A
FROM table_a A
A.Sum = @Sum
And some rows will be retrieved from the DB.