Hello everyone, is there anyone know any equivalent in Oracle OUTPUT command, I know this command by SQL Server, and it's been awhile that I'm trying to search but unsuccessfully. And I use quite this command.

By the way the comand in SQL Server is (im my exemple), and works:


UPDATE TBLVWCLIENT
SET NAME='ROGER'
OUTPUT Inserted.*
WHERE CDCLIENT=311 AND CDEMP=501;

:D