1. How to count newly inserted records in a table of oracle, as in SQL Server

SELECT COUNT(*) FROM inserted

How the similar can be obtained in Oracle.


2. How to call a stored proc. from 'SQL>' prompt. For example I have a procedure defined as,

CREATE OR REPLACE PROCEDURE mytest (var IN OUT varchar2)
AS
BEGIN
INSERT INTO TEST (Name, Age)
VALUES ('aaa',25);
END;
/

Now i want to execute this from the sql prompt.


Thanks in advance.