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;
/

What are different types of tables in sql?

978

---

define join and explain different type of joins? : Sql dba

934

---

What is recursive join in sql?

984

---

What is the maximum number of columns in sql table?

1150

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

1117

---

What are crud methods?

1014

---

What is fmtonly in sql?

1061

---

What is the purpose of a sql?

961

---

What is set serveroutput on in pl sql?

1272

---

Why do we need pl sql?

955

---

What is the difference between a query and a report?

950

---

Why is partition used in sql?

1104

---

What are the advantages of stored procedure?

989

---

What are aggregate functions in sql?

1139

---

How does index help in query performance?

1013

---