what is the use of local variables in pl-sql @@Identity

Question

why use Local variables like @@Identity @@Error....

Santhosh Kumar Jayaraman · Answer

@@Identity is a system function that returns the last-inserted identity value. After an INSERT SELECT INTO or bulk copy statement is completed @@IDENTITY contains the last identity value that is generated by the statement. If the statement did not affect any tables with identity columns @@IDENTITY returns NULL. If multiple rows are inserted generating multiple identity values @@IDENTITY returns the last identity value generated. http://msdn.microsoft.com/en-us/library/ms187342.aspx @@Error - Returns the error number for the last Transact-SQL statement executed. Returns 0 if the previous Transact-SQL statement encountered no errors. Returns an error number if the previous statement encountered an error. http://msdn.microsoft.com/en-us/library/ms188790.aspx