How can we Get the Updated Rows? ie, There is 100s of Rows i
updated the Rows who have salary 5000. then i want to select
the Updated Rows. How can we achieve it?
Answer Posted / mahesh
create table t1 as select * from emp where 1=2;
create or replace trigger t1
after update on emp
for eachrow
begin
insert into t1
values(empno,'ename',job,'hiredate',sal,comm,deptno);
end;
after create trigger
then u updated.
Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What are pl/sql cursor exceptions?
define sql update statement ? : Sql dba
How do I write a sql query in pgadmin 4?
What is information schema in sql?
Is join and inner join the same?
What is clustered and nonclustered index in sql?
Enlist the data types that can be used in pl/sql?
Does a primary key have to be a number?
What are sql commands?
What is a unique constraint?
Do foreign keys improve performance?
How to use boolean type in select statement?
What are the syntax and use of the coalesce function?
How do you delete data from a table?
How to connect a sql*plus session to an oracle server?