1. Oracle is slightly different in this respect. Old and New values are only available when configuring the trigger to execute for each row. As such, the Old and New references only contain one row of data. They also are not tables. You can not include them in the FROM clause, only in the WHERE.

2. At the SQL> prompt type BEGIN and pres Enter. At the next line, type the name of your SP with the parameters enclosed in parentheses followed by a semicolon. At the next line, type END;. Then type / to execute the block.

HTH.

>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.