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 the maximum number of columns in sql table?

1151

---

How many sql statements are used?

1004

---

Explain the difference between triggers and constraints?

963

---

What is left join example?

936

---

How to prepare for oracle pl sql certification?

1049

---

how many sql ddl commands are supported by 'mysql'? : Sql dba

1005

---

What is trigger explain it?

998

---

What is materialized view. What are different methods of refresh?

1370

---

How do you explain an index number?

1083

---

what is index? : Sql dba

991

---

Explain dml and ddl?

969

---

What is a pl/sql block?

1202

---

What is synonyms?

1043

---

How do I run a sql script?

1122

---

What are field types?

981

---