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
(
@Sum INT
)
AS
SELECT *
FROM table_a A
WHERE
A.Sum = @Sum

And some rows will be retrieved from the DB.