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'

Can we insert data in view?

970

---

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

935

---

What is string join?

981

---

what is unique key constraint? : Sql dba

1044

---

Can you do multiple joins in sql?

1056

---

How do I edit a stored procedure?

998

---

what is innodb? : Sql dba

1114

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

---

What are character functions in sql?

943

---

What are the steps for performance tuning.

1341

---

What is difference between db2 and sql?

1008

---

What are inner outer left and right joins in sql?

1017

---

What is difference between sql and mysql?

1136

---

How long does it take to learn pl sql?

1066

---

What is pl sql commands?

1049

---