Answer Posted / rami reddy

CREATE TABLE STUDENT(SNO NUMBER(4),SNAME VARCHAR2(20),COURSE VARCHAR2(20));
ANOTHER TABLE
CREATE TABLE NEW_STUDENT(SNO NUMBER(4),SNAME VARCHAR2(20));
NOW WECAN CREATE TRIGGER FOR AUTO_INSERT FROM TABLE STUDENT TO NEW_STUDENT.AT THAT WE CAN USE 'AFTER INERT' AND 'SELECT' IN THAT TRIGGER, AT THAT WE GET THIS TYPE OF ERROR

1 CREATE OR REPLACE TRIGGER ATUO_INSERT1
2 AFTER INSERT ON STUDENT
3 FOR EACH ROW
4 BEGIN
5 INSERT INTO NEW_STUDENT
6 SELECT :NEW.SNO,:NEW.SNAME FROM STUDENT;
7* END AUTO_INSERT1;
SQL> /

Trigger created.

SQL> INSERT INTO STUDENT VALUES(120,'RAJ','ORACLE');
INSERT INTO STUDENT VALUES(120,'RAJ','ORACLE')
*
ERROR at line 1:
ORA-04091: table SCOTT.STUDENT is mutating, trigger/function may not see it
ORA-06512: at "SCOTT.ATUO_INSERT1", line 2
ORA-04088: error during execution of trigger 'SCOTT.ATUO_INSERT1'

What is Materialized View? In What Scenario we Use Materialized View?

9396

---

what is a database? : Sql dba

1097

---

How do you know if a relationship is 2nf?

877

---

Why truncate is used in sql?

936

---

Explain the purpose of %type and %rowtype data types with the example?

925

---

What is the difference among union, minus and intersect?

949

---

How can we implement rollback or commit statement in a trigger?

979

---

What are the sql versions?

893

---

What is difference between procedure and trigger?

915

---

Is join and inner join the same?

940

---

What are the types of sql commands?

1018

---

What is the difference between delete and truncate statement in sql?

1009

---

What are the types of keys?

931

---

Is nosql faster than sql?

970

---

How does cross join work in sql?

956

---