Answer Posted / anil

CREATE table trg_tab
(ename VARCHAR(10),
sal NUMBER);
/
CREATE table log_tab
(usr VARCHAR(10),
upd DATE,
ename VARCHAR(10),
sal NUMBER
);
/
CREATE OR REPLACE TRIGGER log_trg
AFTER INSERT ON trg_tab
FOR EACH ROW
DECLARE
v_user VARCHAR(10);
BEGIN
SELECT USER
INTO v_user
FROm DUAL;
INSERT INTO log_tab
VALUES (v_user,SYSDATE,:NEW.ename,:NEW.sal);
END;
/
INSERT INTO trg_tab
SELECT ename,sal FROm emp;
/
SELECT * FROm log_tab;
/

Explain isolation levels. : Transact sql

1077

---

Can we join 3 tables in sql?

1053

---

What is embedded sql with example?

1058

---

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

961

---

How do I write a cron which will run a sql query and mail the results to agroup?

992

---

What does desc stand for?

1076

---

What do you mean by table in sql?

999

---

Explain lock escalation? : Transact sql

1210

---

how to select unique records from a table? : Sql dba

1120

---

What is the use of sqlerrd 3?

947

---

What is int identity in sql?

1152

---

What is plpgsql language?

1070

---

Why functions are used in sql?

999

---

What is the process of copying data from table a to table b?

1097

---

what is 'mysqldump'? : Sql dba

1115

---