CREATE SET TABLE test_student ,
	NO FALLBACK,
	LOG,
	CHECKSUM = DEFAULT ( 
	stud_id    	BIGINT DEFAULT 20,
	f_name     	VARCHAR(25) CHARACTER SET LATIN DEFAULT 'diemntrix',
	course_name	VARCHAR(50) CHARACTER SET LATIN DEFAULT 'diemntrix' 
	)
GO
GRANT SELECT, INSERT, UPDATE, DELETE, INDEX, REFERENCES, CREATE TRIGGER, DROP TRIGGER, DUMP, RESTORE, DROP TABLE, STATISTICS ON tduser.test_student TO DBC WITH GRANT OPTION
GO

CREATE SET TABLE test_dept_audit ,
	NO FALLBACK,
	LOG,
	CHECKSUM = DEFAULT ( 
	stud_id    	BIGINT DEFAULT 20,
	f_name     	VARCHAR(25) CHARACTER SET LATIN DEFAULT 'diemntrix',
	course_name	VARCHAR(50) CHARACTER SET LATIN DEFAULT 'diemntrix' 
	)
GO

CREATE TRIGGER test_inserttrigger_students
AFTER INSERT ON test_student
REFERENCING NEW_TABLE AS studentnew
FOR EACH STATEMENT
( INSERT INTO test_dept_audit(stud_id,f_name,course_name) SELECT stud_id,f_name,course_name FROM studentnew;)
GO

ALTER TRIGGER test_inserttrigger_students DISABLED
GO

INSERT INTO test_student(stud_id, f_name, course_name) 
	VALUES(1, 'raghav', 'oracle')
GO

ALTER TRIGGER test_inserttrigger_students ENABLED;
GO

INSERT INTO test_student(stud_id, f_name, course_name) 
	VALUES(2, 'rohit', 'mysql')
GO

SELECT * FROM test_dept_audit
GO

SELECT * FROM test_student
GO